convert negative numbers to positive numbers and vice versa

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

multiply by minus one.

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" <[email protected]> wrote in message
news:[email protected]...
>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

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.

"bill gras" wrote:

> 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

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

regards bill
--
bill gras


"Fred Smith" wrote:

> 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" <[email protected]> wrote in message
> news:[email protected]...
> >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
>
>
>