How to ignore the signs and make the functions work

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

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to input the data as per the quantity 1
Formula for counting and dividing 2
how to change the alphabets to numbers and numbers to alphabets in 2
How can I add numbers but ignore the minus signs? 2
how to make a formula ignore blank cells 6
How to multiply arrays and get the largest number in the resultingarray ? 11
Function: Ignore Mimimum and Maximum Values 4
How to make average function ignore MIN and MAX 6

Top