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