How to ignore the signs and make the functions work

  • Thread starter Thread starter Igneshwara reddy
  • Start date Start date
I

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
 
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
 
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
 
Back
Top