Greater Than, Less Than, or Equal To separately NOT combined

[ChrisOK]

Having a brain lapse on how to do this formula where one of 3 results will be return..
=IF(AND(M1>N1,M1<N1,M1=N1),"GREATER","LESS","EQUAL")

The abv formula obviously doesn't work -- too many arguments -- but I don't want to combine and EQUAL TO with a > or <.

I want each response separate:

CELL M1......CELL N1......CELL O1 (formula result)
....36.............36............EQUAL.....(M1 is equal to O1)
.
.....10.............36...........LESS........(M1 is LESS THAN N1)
.
....36.............5..............GREATER...(M1 is GREATER THAN N1)

 

[Rick Rothstein]

Here is one way to do it...

=CHOOSE(SIGN(M1-N1)+2,"LESS","EQUAL","GREATER")

 

[Marcelo Branco]

oops... EDIT

Try

=IF(M1=N1,"EQUAL",IF(M1>N1,"GREATER","LESS"))

M.

 

[AkaTrouble]

this might be what you after

=IF(N1=M1,"EQUAL",IF(N1>M1,"GREATER THAN","LESS THAN"))

 

[AkaTrouble]

Try

=IF(M1=O1,"EQUAL",IF(M1>O1,"GREATER","LESS"))

M.

sorry was testing and posting while you replied

 

[ChrisOK]

LOVE them all --- I've tested each and each work perfectly, (with the exception of Marcelo) - I needed to edit the fields to use M1 and N1 (instead of O) and all was good... Thanks to all of you for the expeditious and unique fixes!! You're AWESOME!

 

[Marcelo Branco]

You are very welcome,

My formula had a typo - i edited but it was too late - thanks for correcting it.

M.