+ Reply to Thread
Results 1 to 5 of 5

how to turn positive to negative values in excel

  1. #1
    Paula1
    Guest

    how to turn positive to negative values in excel

    I have a list of values which are positive or negative depending on a D or C
    value in the cell next to them. I need to turn the D values to negatives in
    order to sum the data

  2. #2
    Elkar
    Guest

    RE: how to turn positive to negative values in excel

    Are your values manually entered, or results of a formula? If manually
    entered, then you'll probably need to insert a new column and then use this
    formula:

    For this example, I'm assuming Column A holds D or C info, and Column B
    holds your values. This formula would then be entered in Column C.

    =IF(A1="D",-B1,B1)

    But if your values are the results of a formula, then you could most likely
    incorporate the above logic into the existing formula to avoid using an
    additional column.

    HTH,
    Elkar


    "Paula1" wrote:

    > I have a list of values which are positive or negative depending on a D or C
    > value in the cell next to them. I need to turn the D values to negatives in
    > order to sum the data


  3. #3
    Bob Phillips
    Guest

    Re: how to turn positive to negative values in excel

    How about summing them without changing anything

    =SUM(IF(B1:B10="D",-A1:A10,A1:A10))

    which is an array formula, it should be committed with Ctrl-Shift-Enter, not
    just Enter.

    --
    HTH

    Bob Phillips

    (remove nothere from email address if mailing direct)

    "Paula1" <Paula1@discussions.microsoft.com> wrote in message
    news:CE3D7B64-62E3-42C4-9033-8115D2C385D2@microsoft.com...
    > I have a list of values which are positive or negative depending on a D or

    C
    > value in the cell next to them. I need to turn the D values to negatives

    in
    > order to sum the data




  4. #4
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676
    or even

    =SUMIF(B1:B10,"C",A1:A10)-SUMIF(B1:B10,"D",A1:A10)

  5. #5
    Bob Phillips
    Guest

    Re: how to turn positive to negative values in excel

    yeah ... good :-)

    --
    HTH

    Bob Phillips

    (remove nothere from email address if mailing direct)

    "daddylonglegs" <daddylonglegs.23pdrb_1140733204.49@excelforum-nospam.com>
    wrote in message
    news:daddylonglegs.23pdrb_1140733204.49@excelforum-nospam.com...
    >
    > or even
    >
    > =SUMIF(B1:B10,"C",A1:A10)-SUMIF(B1:B10,"D",A1:A10)
    >
    >
    > --
    > daddylonglegs
    > ------------------------------------------------------------------------
    > daddylonglegs's Profile:

    http://www.excelforum.com/member.php...o&userid=30486
    > View this thread: http://www.excelforum.com/showthread...hreadid=515965
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1