Currency Rounding to nearest 5 cents

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.

Thanks in advance for you help

Daniel

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

=ROUND(B1/0.05,0)*0.05

=round(a1/0.05,0)*0.05

hth
regards from Brazil
Marcelo

"Daniel Sloan" escreveu:

>
> 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.
>
> Thanks in advance for you help
>
> Daniel
>
>
> --
> Daniel Sloan
> ------------------------------------------------------------------------
> Daniel Sloan's Profile: http://www.excelforum.com/member.php...o&userid=28940
> View this thread: http://www.excelforum.com/showthread...hreadid=563056
>
>

"Daniel Sloan" <Daniel.Sloan.2b7ne6_1153342808.7607@excelforum-nospam.com>
wrote in message
news:Daniel.Sloan.2b7ne6_1153342808.7607@excelforum-nospam.com...
>
> 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)
--
David Biddulph