Try this:

For a value in A1

This formula uses 5/4 rounding to the nearest muliple of 0.05
B1: =MROUND(A1,0.05)

Note: MROUND requires the Analysis ToolPak to be enabled.
If that doesn't appeal to you...try this:
B1: =ROUND(A1/5,2)*5

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"JM" wrote:

looking for the formula that will round up to the nearest nickel.

For example, have a price of $2.21 would round to $2.20 and $2.23 would
round to $2.25.

thanks