=MAX(ABS(A1:C1))

ctrl+shift+enter, not just enter


"Igneshwara reddy" wrote:

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