How to ignore the signs and make the functions work

[Igneshwara reddy]

Hi,

I need to have a formula which ignore the signs.

Row A1 RowB1 RowC1(Results)
-10 9 10

I need to findout which is the greater number from both ignoring the signs.
Sign should not consider. I have used the MAX formula but it is using the
sign when arrive to the results.

Do the needful at the earliest.

Regards,
Igneshwara reddy

 

[Teethless mama]

=MAX(ABS(A1:C1))

ctrl+shift+enter, not just enter

 

[Igneshwara reddy]

yes this formula is working fine but the result should be with sign -10 only.
Sorry I missed this point to state in the below email.

Regards,
Igneshwara reddy

 

[T. Valko]

Try tis:

=INDEX(A1:B1,MATCH(MAX(INDEX(ABS(A1:B1),1,)),INDEX(ABS(A1:B1),1,),0))

If both cells have the same number but different signs the formula will
return the sign of the *first* cell. For example:

A1 = -10
B1 = 10

Result is -10