Tags: an54ao4000, column, convert, d53, d54, excel, false, formulas, microsoft, msdn, negative, numbers, positive, software, versa, vice, vlookup

convert negative numbers to positive numbers and vice versa

On Microsoft » Microsoft Excel

4,136 words with 4 Comments; publish: Wed, 04 Jun 2008 15:20:00 GMT; (30662.50, « »)

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

All Comments

Leave a comment...

  • 4 Comments
    • 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" <billgras.excel.todaysummary.com.discussions.microsoft.com> wrote in message

      news:4EC17567-3201-4410-ABB7-0DF2E8601510.excel.todaysummary.com.microsoft.com...

      >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

      #2; Wed, 04 Jun 2008 15:22:00 GMT
    • 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

      #3; Wed, 04 Jun 2008 15:23:00 GMT
    • 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" <billgras.excel.todaysummary.com.discussions.microsoft.com> wrote in message

      > news:4EC17567-3201-4410-ABB7-0DF2E8601510.excel.todaysummary.com.microsoft.com...

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

      >

      >

      #4; Wed, 04 Jun 2008 15:24:00 GMT