How do I set up a function in excel to give either a <> or =?

[ivory]

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,

 

[Simon Lloyd]

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,There are smarter ways but assuming your numbers are in column A & B put

this in C and copy down.
=IF(A1>B1,"A1 High",IF(B1>A1,"B1 High",IF(A1<B1,"A1 Low",IF(B1<A1,"B1
Low","A1 & B1 Equal"))))


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)

 

[Mike H]

Simon

The A1 low & B1 low can never be called because B1 high or A1 high will
evaluate as TRUE first.

Mike

 

[Rick Rothstein]

Give this a try...

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

 

[Simon Lloyd]

Your right Mike, i didn't see that when cobbling that together!

Simon

The A1 low & B1 low can never be called because B1 high or A1 high will
evaluate as TRUE first.

Mike



numbers are in column A & B put
Office Discussion' (http://www.thecodecage.com))
Lloyd' (http://www.thecodecage.com/forumz/member.php?userid=1)

--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)

 

[ivory]

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