Round Price to the Nearest Nickel

If you want to avoid pennies, you can round prices to the nearest nickel using the following formula:


If you want to round UP to the nearest nickel, you can change the above formula to use ROUNDUP instead of ROUND, or you can use the CEILING formula:

To round DOWN, you can use the FLOOR formula:


Anonymous said...

What does the star represent?

Anonymous said...

Asterisk is what Excel uses for multiplication symbol.