Carrying Over Negative number to next column as a positive number

**Redraven** · 08-21-2014, 06:37 AM

I go negative in one column I want it to show up in the next column as a positive number because when I add my income and subtract my bills and the negative from last month to get the what cash I'll have left it screws up because negative subtract a negative is a positive. So how do i get the sum of say B9 to from -$5.00 to +$5.00 into C4 so when i subtract C4 From my income it wont add to it.

I hope some understands this

please let me know if I need to explain better.

**Special-K** · 08-21-2014, 06:39 AM

Use ABS()

Absolute formula changes everything into positive (apart from zero which is neither).

Alternatively perhaps you should just be adding values instead of subtracting.