how to turn positive to negative values in excel

G

Guest

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
 
G

Guest

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
 
B

Bob Phillips

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

summing only positive or negative values 2
Reallocate array cells value from positive to negative 0
How to Show "+" for positive and "-" for negative 10
Subtracting positive amts from negative and positive from positive 3
HOW DO I SEPERATE POSITIVE AND NEGATIVE VALUES FROM A COLUMN 5
Need Help with "SUM" AND "ABS" in same formula 12
subtract a positive from a negative 7
If sign of sum is negative change to positive 1

Top