Use a lookup table.
In cell E1 enter 0, in E2 enter 301, in E3 enter =E2+300 copy E3 down
through E4:E21

In cell F1 enter ="$"&E1&" to $"&E2-1
Copy down through cells F2:F20
In cell F21 enter "Over $6000"

In cell A2 enter
=VLOOKUP(A1,$E$1:$F$21,2)

Move location of table to suit and change ranges in formula.


Regards

Roger Govier


tysonstone wrote:
I need help creating a cost range for the following scenario.
If the value of cell A1 falls between 0-300 I need the following cell A2 to
say $0-$300 or if A1 was 389 I would need A2 to say $300-$600 and so on. In
need it broke down in $300 increments to $6000. Thank You