I am not sure if Excel is capable of doing this, but hopefully someone out
there knows. I am trying to create a formula to do the following: In one
cell I will have a running total and in the other cell I want to enter a
number that will carry over to the cell with the running total in turn making
that cell blank until another number is entered.

Example: Cell One, enter the number three, Cell Two, current number 150
will change to 153 and Cell One will go back to a blank cell util used again.

????? This would be a great time saver if this is possible.