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.. |
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. |
Quote:
|
All times are GMT +1. The time now is 06:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com