=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:

What does the star represent?

Asterisk is what Excel uses for multiplication symbol.

Post a Comment