ExcelBanter - Nested "if" for price list

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Nested "if" for price list (https://www.excelbanter.com/excel-worksheet-functions/80063-nested-if-price-list.html)

simmerdown

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.

vezerid

Nested "if" for price list

Use CEILING(A2,10). All prices from 0.01 to 10 will show 10.

HTH
Kostis Vezerides

All times are GMT +1. The time now is 12:05 AM.