THIS IS GREAT,
THANK YOU.

"Sloth" wrote:

="$"&A1-MOD(A1,300)&"-$"&300+A1-MOD(A1,300)

This formula should work for you. This puts numbers in the upper portion of
their range (ie. 0 in A1 results in $0-$300 in A2, and 3600 in A1 results in
$3600-$3900 in A2.


"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