convert negative numbers to positive numbers and vice versa
If, as your subject says, you want to convert negative to positive, and vice
versa, simply put a minus sign in front of your formula, as in:
=-VLOOKUP(D53,AN54:AO4000,2,FALSE)
If, as the body of your message says, you want to convert negative to positive,
but leave the positive results as is, use:
=ABS(VLOOKUP(D53,AN54:AO4000,2,FALSE))
--
Regards,
Fred
"bill gras" wrote in message
...
I have in column A formulas e g :
=VLOOKUP(D53,AN54:AO4000,2,FALSE) result -45
=VLOOKUP(D54,AN54:AO4000,2,FALSE) result -67
=VLOOKUP(D55,AN54:AO4000,2,FALSE) result 78
=VLOOKUP(D56,AN54:AO4000,2,FALSE) result -4
=VLOOKUP(D57,AN54:AO4000,2,FALSE) result 49
=VLOOKUP(D58,AN54:AO4000,2,FALSE) result 23
=VLOOKUP(D59,AN54:AO4000,2,FALSE) result - 34
how can I convert negative numbers to positive numbers ?
regards bill
--
bill gras
|