Positive to a Positive and Negative to a Positve

I am trying to design a formula to leave the positive number alone however the negative numbers need to change to positive.services I was trying to get all the totals positive so I can create a pivot table In a excel spreadsheet that has account and balances but the deposit are shown in a negative value (1234):

Negatives Balances Formula
(1234.00) 1234.00 =IF(D4,-D4,-D4)
(1234.00) 1234.00 =IF(D5,-D5,-D5)
1234.00 (1234.00) =IF(D6,-D6,-D6)
1234.00 -(1234.00) =IF(D7,-D7,-D7)

Is there a way to do a nested If statement to achieve this?

Thanks
Art Lorenzini
Sioux Falls, SD

Hi,

I am trying to design a formula to leave the positive number alone however the negative numbers need to change to positive

Use the ABS() function

eg.

=ABS(D4)