Help required for formula

[recklaw]

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?

 

[davesexcel]

=IF(A1=B1,"Z",IF(A1<B1,"Y","X"))
This should work

 

[recklaw]

Just to let you all know I managed to work it out
I nested my formula using the following: -

=IF(A2>B2,"X",IF(A2<B2,"Y", IF(A2=B2,"Z"))