"><" formula needed

[Guest]

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

 

[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

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 20
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?:

 

[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

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

identify all the numbers to each other and return the
following result?:

 

[Guest]

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