Round Price to the Nearest Nickel

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

=ROUND(value/0.05,0)*0.05

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:
=CEILING(value,0.05)
=ROUNDUP(value/0.05,0)*0.05

To round DOWN, you can use the FLOOR formula:
=FLOOR(value,0.05)
=ROUNDDOWN(value/0.05,0)*0.05

2 comments:

  1. Anonymous11:55 AM

    What does the star represent?

    ReplyDelete
  2. Anonymous8:46 AM

    Asterisk is what Excel uses for multiplication symbol.

    ReplyDelete