Currency Rounding to nearest 5 cents

[Daniel Sloan]

Hi

I have a price list to update and want to know how to use an exce
formula to round the result to the nearest whole 5cent value.

Thanks in advance for you help

Danie

 

[MDubbelboer]

find out how many nickels...times by the price of a nickel...

=ROUND(B1/0.05,0)*0.0

 

[Marcelo]

=round(a1/0.05,0)*0.05

hth
regards from Brazil
Marcelo

"Daniel Sloan" escreveu:

 

[David Biddulph]

"Daniel Sloan" <[email protected]>
wrote in message

Hi

I have a price list to update and want to know how to use an excel
formula to round the result to the nearest whole 5cent value.

=MROUND(A1,0.05)