how to turn positive to negative values in excel

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

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. 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. or even

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

5. Re: how to turn positive to negative values in excel

yeah ... good :-)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

wrote in message
>
> or even
>
> =SUMIF(B1:B10,"C",A1:A10)-SUMIF(B1:B10,"D",A1:A10)
>
>
> --
> ------------------------------------------------------------------------

http://www.excelforum.com/member.php...o&userid=30486
>

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

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