Creating a group of cells. Need Help Please.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Thundersixx - 17 Jan 2006 15:41 GMT

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

Reply to this Message

Debra Dalgleish - 17 Jan 2006 16:46 GMT

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.

> Havn't used excel in a while and I need to create a group of cells
> corresponding to an input of a min and a max.
[quoted text clipped - 3 lines]
> column starting at A2 to output (MIN,A2+1000,A3+1000,....MAX) how
> would I do this?

Signature

Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Reply to this Message