Creating a group of cells. Need Help Please.

T

Thundersixx

Havn't used excel in a while and I need to create a group of cell
corresponding to an input of a min and a max.

Here are the details. On one sheet I have a box where you enter th
min and a box where you enter the max. In another sheet I want
column starting at A2 to output (MIN,A2+1000,A3+1000,....MAX) ho
would I do this
 
D

Debra Dalgleish

Name the cells that contain the min and max amounts, as described here:

http://www.contextures.com/xlNames01.html

Assuming you named the cells MinAmt and MaxAmt, on the second sheet, in
cell A2, enter the formula: =MinAmt

In cell A3, enter the formula:

=IF(OR(A2=MaxAmt,A2=""),"",IF(A2+1000<=MaxAmt,A2+1000,MaxAmt))

Copy the formula down as far as required to accommodate the largest max
amount that will be used.
 
Top