repeat a calculation in excel

Hey

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?

microsoftoffice excel spreadsheet numbers iwork formula

asked Dec 01 '12 at 10:45

DJDhan
176●35●35●42

2 Answers:

0	You do realise that that's just the 4 times table in reverse, right? answered Dec 02 '12 at 06:08 dunfiddlin 1.2k●4●18

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

trueb
15.4k●53●104●260

Your answer

toggle preview

community wiki

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or __italic__
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported