Monday, October 5, 2009

Count by Increments in Excel

So you may be wondering how to make a list in excel go from one specified number to another in user defined increments. Well I recently had to use this application myself and this is the format I used. A user enters the number the start counting from in the first yellow square, the number to end at in the next, and finally in what increments they would like to count up at. Here is the driving formula:

=IF(I2="","",IF(I2+1*$F$1<=$D$1,I2+1*$F$1,"")) and =B1 in cell I2.

Pictured are two examples.

No comments: