Hello, i have a problem with excel....
I need to make three cells, Added, Sold and Total.
The cell total needs to be the total amount of cans i have in my shop. So lets say 10.
When i add 5 into the cell Added my total should be 15, this i can do
BUT! when i remove the 5 from the cell added, the total cell has to stay 15, untill i put 5 into the SOLD cell.
Is there a way to do this
If your Total formula looks like this
=10 + Added
then include Sold
=10 + Added - Sold
In terms of cell references with C2 being in the Total column, A2 being in the Added column and B2 being in the Sold column in C2 put this formula.
=10 + A2 - B2
C2 won't update until you put a number like 5 in B2 or in A2.
Does that help?
Last edited by FlameRetired; 09-02-2015 at 02:06 PM.
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks