I want to create a worksheet for repeated subtraction to zero
For example it would look like this
444 - 4 = 440
436 - 4 = 432
432 - 4 = 428
It would do this 111 times till zero automatically is there any way to do this in Excel?
You do realise that that's just the 4 times table in reverse, right?
answered Dec 02 '12 at 06:08
in column A put your first number
in column B put your second number
in column C put your formula.
make 2 lines with this so excel knows how much to decrement by each time
highlight all 3 cells and click and drag it down as far as you want.
answered Dec 02 '12 at 09:27