Hi

Very neat solution! Well done.

Regards

Roger Govier


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