Ceiling with significance

1 post / 0 new
Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57
Ceiling with significance

The ceiling with significance returns number rounded up, away from zero, to the nearest multiple of significance. For example, if you want to avoid using pennies in your prices and your product is priced at $4.42, use the formula =Ceiling(4.42,0.05) to round prices up to the nearest nickel.