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


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

Currency Rounding to nearest 5 cents
 

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

=ROUND(B1/0.05,0)*0.05


--
MDubbelboer
------------------------------------------------------------------------
MDubbelboer's Profile: http://www.excelforum.com/member.php...o&userid=36330
View this thread: http://www.excelforum.com/showthread...hreadid=563056

Currency Rounding to nearest 5 cents
 

=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

Currency Rounding to nearest 5 cents
 

"Daniel Sloan"
wrote in message
news:Daniel.Sloan.2b7ne6_1153342808.7607@excelforu m-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