Round Amount

[Moideen]

We are using bahrain Currecny, Kindly Help me to get the below mentione
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]

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]

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

9.925), replace MROUND with CEILING, and replace ROUND with ROUNDUP.

Thank you very much