Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rounding to the Nearest Eighth | Excel Discussion (Misc queries) | |||
Rounding to nearest 5 cents in excel | Excel Worksheet Functions | |||
Rounding up to the nearest nickel | Excel Discussion (Misc queries) | |||
I am trying to round up to the nearest 25 cents | New Users to Excel | |||
Rounding to nearest integer | Excel Worksheet Functions |