| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested "if" for price list
How do I write an "if" statement to group a price list?
For example, if I have a list of prices and I want to group them in $10 increments Under $10 $10.01 - $20.00 $20.01 - $30.00 etc. etc. Over $200 Thank you. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Nested "if" for price list
Use CEILING(A2,10). All prices from 0.01 to 10 will show 10.
HTH Kostis Vezerides |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| update data validation list with new entries?? | Excel Discussion (Misc queries) | |||
| List box setup, placement, and functionality | New Users to Excel | |||
| Data Validation and Blanks in List | Excel Worksheet Functions | |||
| Refresh a Validation List? | Excel Discussion (Misc queries) | |||
| Creating a list from an existing list. | Excel Worksheet Functions | |||
Hybrid Mode
