Thread: How do I set up a function in excel to give either a < or =?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein Rick Rothstein is offline
external usenet poster
  
Posts: 5,934
Default How do I set up a function in excel to give either a < or =?
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,


Reply With QuoteReply With Quote