Conditions if nested

Asked

Viewed 68 times

0

I would like to create a formula SE using the following conditions:

1-Se A for maior ou igual a 1 e menor ou igual a 3 devolve B, caso não 0
2-Se A for maior ou igual a 4 e menor ou igual a 6 devolve B, caso não 0
3-se A for maior ou igual a 7 e menor ou igual a 9 devolve B, caso não 0
4-Se A for maior ou igual a 10 devolve B, caso não 0

I’ve tried using the following formula that didn’t work:

=IF(A1<=3,z1,0) That formula would require me to calculate four times to get the same result. My difficulty is synthesizing the formula to include all ranges from 1-3; 4-6; 7-9; 10-more.

excel

  • =IF(A1<=3,Z1,0)

  • Edit the question and add what you’ve tried to do, and explain your difficulty.

  • My difficulty is to compose the formula that gives me the right result. I tried to use the one that’s up there but it’s not working.

2 answers

0

I believe that the desired formulas are these:

=SE(E(A2>=1;A2<=3);Z2;0)   'cenário 1
=SE(E(A2>=4;A2<=6);Z2;0)   'cenário 2
=SE(E(A2>=7;A2<=9);Z2;0)   'cenário 3
=SE(A2>=10;Z2;0)           'cenário 4

The result should be something like this, despite not knowing how your spreadsheet:

Exemplo 1

Exemplo 2

0

You need to match the function SE with the function E.

The function SE has the following format:

SE(condição;resultado se verdadeiro;resultado se falso)

Already the function E has the format:

E(teste lógico 1;teste lógico 2;...)

In your case, you need something like this:

=SE(E(A1>1;A1<5);B1;0)

Browser other questions tagged excel

You are not signed in. Login or sign up in order to post.