IF statement within an IF statement

[bdschleich]

I am trying to structure an IF statement within an IF statement and I am not sure how to structure the formula properly.

More specifically, I have the following formula: =IF(B2=X, Y, Z) and I want to then subsequently have another IF statement within the same cell that will then check for the following condition: IF(Statement above > A, B, Statement above).

Any thoughts on how this formula should be written so that it is all one formula wihin a cell?

 

[Oaktree]

Sure.

Try:

=if(B2=500,"B2 equals 500", if(B2>500, "B2 is greater than 500", "B2 is less than 500"))

 

[taylor1010]

Hi
I am trying to create an if statement for multiple values (18) and I tried using the following but the limit is 7 - =IF(SEARCH("SOUTHPOINT",A:A),"SOUTHPOINT",),IF(SEARCH("DUBLIN",A:A),"DUBLIN",), and so on with 16 more values but it wont let me do more than 7, how does one extend the if formula to the amount I need?