Nested "if" for price list

[simmerdown]

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]

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

HTH
Kostis Vezerides