Formula that will both add and subtract in a single cell

Hello

give a sample of some cells to help you

a formula in one cell cannot influence by itself another cell... D2 will have it's own formula

nope, still don't get the picture

Show us at least 4 lines only with data - no calculations

Show again same 4 lines with results, done manually (by you with the correct values) and explain

I believe that then we'll be able to help

Sounds like you need to write a nested formula.  Could you give an example of what you have already written in the cell that you want to add and subtract in?  This way we could then suggest nested formulas that would most likely provide you with the right answer. :).

But I need to refrence both cells.  Kind of like if I was only doing a SUM function.  The only difference is, that I want it to both add and subtract within on formula.

This what part of my spreadsheet looks like.  So where it says 118(Total Quantity on hand),that is in cell C2. Now, in D2 is where I am going to be adding or subtracting quantities, then I want the adjusted amount to populate in cell E2 where it says "Total Comforts.  If I use a SUM function, it will add to the total number, but then when I subtrack, it take all the numbers I have added to E2 adds those together and then subtracks all of it from my quantity on hand.  For example, 118 in stock, I add 12.  This gives me 132 in stock. Then I save my changes.  Come back to it, subtract 2, and instead of subtracking 2, it subtracts 14.  See what I'm saying?