How to ignore the signs and make the functions work
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
"Teethless mama" wrote:
=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
|