Thank you so much, that works exactly the way I needed it.
Ivory

"Rick Rothstein" wrote:

Give this a try...

=CHOOSE(2+SIGN(A1-B1),"Lower","Equal","Higher")

--
Rick (MVP - Excel)


"ivory" wrote in message
...
I have two columns that have two numbers and I need a function that will
tell
me if the one number in one column is greater than, less than< or equal
=.

Thank you for your help,