ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Round Amount (https://www.excelbanter.com/excel-discussion-misc-queries/427571-round-amount.html)

Moideen

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

joeu2004[_2_]

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.


Moideen

Quote:

Originally Posted by joeu2004[_2_] (Post 1528395)
"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.

Thank you very much.


All times are GMT +1. The time now is 06:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com