| Home |
| Search |
| Today's Posts |
|
#4
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I use named range in data range box when creating pie chart? | Charts and Charting in Excel | |||
| Question regarding dynamic range setting | Excel Worksheet Functions | |||
| Indexing a row | Excel Worksheet Functions | |||
| our cost to customers cost | Excel Worksheet Functions | |||
| Cannot Expand Named Range - when size of the Range exceeds | Excel Discussion (Misc queries) | |||
Threaded Mode
