If formula for a budget worksheet

I am new to this forum but this is due to the fact that I am relatively new to Excel but I absolutely love it.

I am working on a budget worksheet and I need help with a formula. Here is the scenario:

I have a column with my future purchases. Beside it, I have a column for "estimated price"
Beside that I have a column for "actual price"

I have a total row and I also have a "balance (+/-)" to which the total of "estimated" is subtracted from my fixed salary.

What I want to do is to have the ability to enter an "actual spent" amount when the item is purchased and for this amount to have an effect on my "balance (+/-) total. So, essentially, if, for example, my salary is $100. a pair of jeans i want to purchase are estimated to cost $90, thus changing my "balance (+/-)" to $10. but the jeans end up costing $85. How do I change the effect of the balance??

I am assuming I would use an If command or something. For example, If the price of the item in column C > (greater than) actual price, in column D, add the difference as a positive number to the "balance (+/-)

I hope I have explained this properly. Here is an image of the actual sheet (I hope it helps)


Thanks in advance.

Hi EricCity,

For your query please refer the attached excel file.