convert negative numbers to positive numbers and vice versa

[Guest]

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

 

[rsenn]

multiply by minus one.

 

[Guest]

Easiest way is to change the formula:
=abs(vlookup(d53,an54:ao2000,2,false)). If you want to negate a range of
cells, you can also type a -1 in some random cell, copy it, select your range
then Edit > Paste Special, select Multiply and click OK.

 

[Fred Smith]

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

 

[Guest]

Hi Fred , rsenn , bpeltzer
Thank you all for your reply
Just what I was looking for , once again , thanks!

regards bill