If Statements to calculate negative numbers

Hello Forum,

I'm hoping someone can help me out with what I believe is a simple formula that I cannot seem to get to work.

In column C is the amount that I will charge a customer.
In column D is the amount the customer paid me.
In column E is the balance owing.

A simple formula in cell E2 to figure out the balance owing is this:
(E1+C2-D2)

The issue I have is this :
If my customer pays me more than they need to (we work on large projects here and they like to "pre pay" ahead of time), I need it to add their payment to the balance.

I've attached an example.

Would it be easier to have just one cell to display how much is owed.
Then all you need is the total of column C minus the total of column D.
And with the cell formated to go Red for Minus currency numbers, you can see if the account is in credit or not. Or with a minus before the formula to reverse it.

Awesome!
Now if only i knew how to mark this as Solved !!!


thanks all !!

To mark a thread as solved go to your first post of the thread.
At the bottom of the post, click "Go Advanced"
Use the drop-down menu to the left ot the thread title and select Solved.

Also, if you have found another user's input helpful you might want to select the scales in the top right of their posts and click on the scales.

Hope that helps!