Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Round Amount
We are using bahrain Currecny, Kindly Help me to get the below mentioned amount format
eg: 9.922 Round to : 9.925 9.949 Round to : 9.950 9.973 Round to : 9.975 9.988 Round to : 10.000 Pls Help me.. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Round Amount
"Moideen" wrote:
We are using bahrain Currecny, Kindly Help me to get the below mentioned amount format eg: 9.922 Round to : 9.925 9.949 Round to : 9.950 9.973 Round to : 9.975 9.988 Round to : 10.000 Looks like you want to round to the nearest 0.025. You can either of the following formulas: =MROUND(A1,0.025) or =ROUND(A1/0.025,0)*0.025 If you have Excel 2003, MROUND is in the Analysis ToolPak, which you must enable. See the MROUND help page. Note: I assume you want to round, not round up, because of your title. But in fact, your examples are not sufficient to distinguish the two. If indeed you actually want to round up (9.926 becomes 9.950 instead of 9.925), replace MROUND with CEILING, and replace ROUND with ROUNDUP. |
#3
|
|||
|
|||
Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate the amount of time over a permitted amount (12 hours) | Excel Discussion (Misc queries) | |||
How do I get a calculated amount to round to the nearest nickel? | Excel Worksheet Functions | |||
how can i round a dollar amount to the nearest thousand? | Excel Worksheet Functions | |||
How can I calculate amount of time left based on amount spent? | Excel Worksheet Functions | |||
Round amount to nearest $10 after other formula calc. in same cell | Excel Worksheet Functions |