I want to utilise a formula in excel, but am not sure exactly how to enter it
My formula needs to do the following: -
If (A>B) then display x
If (A<B) then display y
If (A=B) then display z
Naturally I would prefer to do this in one cell.
Using the If command it would appear I could set the formula to say : -
=IF(A1>B1,"X","Y")
However this will only display X if A is greater than B and Y if A is less than or equal B.
Is there a way to work out the three different values?
Bookmarks