IF with 3 scenarios?

Hi all,

I have an IF formula as shown below:

=IFERROR(IF(I6>I33,1,2),"3")

So if I6 is greater than I33 it should return a 1, if not then a 2, and if there is an error it will return a 3.

I have second formula which then needs to return a value based on the above:

=IF(X21=2,1,2)

This formula will return the opposite value of the first formula, so if the first formula returns a 1, then this must return a 2 and vice versa however I also need to it to return a 3 if the original formula returns a 3 as a result of the IFERROR.

I am sure this is probably something really basic but I can't seem to get it work so any help would be much appreciated!

First of all, get rid of the quote marks:

=IFERROR(IF(I6>I33,1,2),3)

Next try this:

=IF(X21=2,1,IF(X21=3,3,2))

Hi Ali,

Nice one! That did the trick!

Thank you very much!

You're welcome!