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