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 (AB) 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(A1B1,"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?
--
recklaw
------------------------------------------------------------------------
recklaw's Profile:
http://www.excelforum.com/member.php...o&userid=32469
View this thread:
http://www.excelforum.com/showthread...hreadid=522572