SE - Excel function

Asked

Viewed 46 times

0

Good afternoon!

I’m having trouble making a field true or false but with 3 variables.

  • If A1 and B1 = "N" will be Null
  • If only A1 = "N" will be True
  • If Only B1 = "N" will be False

How can I mount a function in Excel based on this ?

I’m using the basis of =SE(E(A1="N"; True; False);

But I can’t fit the third variable if both are N

Thanks in advance!

excel function fórmula

2 answers

1


You can use the function SES() to create multiple conditionals.

Then the following formula can be created, with three different conditions:

=SES(E($A1="N";$B1="N");"";E($A1="N";$B1<>"N");VERDADEIRO;E($A1<>"N";$B1="N");FALSO)

Upshot

The following result is obtained by inserting the formula in column C:

|   | A | B |     C      |
|---|---|---|------------|
| 1 | N | N |            |
| 2 | N |   | VERDADEIRO |
| 3 |   | N | FALSO      |

  • When I put this formula is appearing the field "#NAME?"

  • 1

    Check in the documentation what this error is: #NAME? and make sure everything is correctly typed in your formula. Functions should be in the Office language, for example SES in Excel in English is IFS. Try to understand the answer formula and not just copy everything and paste.

  • My version of the office package is old and does not have the SES() function, I will update, thank you very much!

1

If your Office version does not have the SES function try:

=SE(E(A1="N"; B1="N"); ""; SE(A1="N"; Verdadeiro; SE(B1="N"; Falso; "Ambos diferentes de N")))

Considering the possibility of the last condition occurring, if such condition is impossible to occur simply change the last SE to False.

Note that you say they are with 3 variables but in your example only 2: A1 and B1.

Browser other questions tagged excel function fórmula

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