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, A1A2, A1B2, B1A2, B1B

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

Bart

but why ?

=IF(A1B1,"A1B1",IF(A1=B1,"A1=B1","A1<B1"))&", "
&IF(A2B2,"A2B2",IF(A2=B2,"A2=B2","A2<B2"))&", "
&IF(A1A2,"A1A2",IF(A1=A2,"A1=A2","A1<A2"))&", "
&IF(A1B2,"A1B2",IF(A1=B2,"A1=B2","A1<B2"))&", "
&IF(B1A2,"B1A2",IF(B1=A2,"B1=A2","B1<A2"))&", "
&IF(B1B2,"B1B2",IF(B1=B2,"B1=B2","B1<B2"))

Regards

Trevor


"Bart" wrote in 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?:
A1<B1, A2<B2, A1A2, A1B2, B1A2, B1B2

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

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?:
A1<B1, A2<B2, A1A2, A1B2, B1A2, B1B2

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

.

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