"><" formula needed

B

Bart

Hi, I have numbers that I would like to compare to each other and determine their relationship to each other as to ">" or "<". Example

A B
1 50 70
2 10 2
3 (result will go here

Is there any formula that I can enter into cell A3 to identify all the numbers to each other and return the following result?
A1<B1, A2<B2, A1>A2, A1>B2, B1>A2, B1>B

I would like it in this form and not in "true or false" form. I use Excel 97
Thank you to anyone that can help
Bart
 
T

Trevor Shuttleworth

Bart

but why ?

=IF(A1>B1,"A1>B1",IF(A1=B1,"A1=B1","A1<B1"))&", "
&IF(A2>B2,"A2>B2",IF(A2=B2,"A2=B2","A2<B2"))&", "
&IF(A1>A2,"A1>A2",IF(A1=A2,"A1=A2","A1<A2"))&", "
&IF(A1>B2,"A1>B2",IF(A1=B2,"A1=B2","A1<B2"))&", "
&IF(B1>A2,"B1>A2",IF(B1=A2,"B1=A2","B1<A2"))&", "
&IF(B1>B2,"B1>B2",IF(B1=B2,"B1=B2","B1<B2"))

Regards

Trevor


Bart said:
Hi, I have numbers that I would like to compare to each other and
Click to expand...
determine their relationship to each other as to ">" or "<". Example:
A B
1 50 70
2 10 20
3 (result will go here)

Is there any formula that I can enter into cell A3 to identify all the
Click to expand...
numbers to each other and return the following result?:
 
G

GJones

Hi Bart;

You should be able to look in help for how to write
an "If" formula to get what you want.

Thanks,

Greg
-----Original Message-----
Hi, I have numbers that I would like to compare to each
Click to expand...
other and determine their relationship to each other as
to ">" or "<". Example:
A B
1 50 70
2 10 20
3 (result will go here)

Is there any formula that I can enter into cell A3 to
Click to expand...
identify all the numbers to each other and return the
following result?:
 
B

Bart

Thanks Trevor! Very helpful and it worked. The reason I needed that is for comparing investment protfolio movements. have alot of data and this sure beats looking at each value and manually figuring out which values are larger or smaller than each other. Thanks again
Bart
 
Top