Rounding To nearest 05 Cents in Excel 97
Author Message
Rounding To nearest 05 Cents in Excel 97

I have a problem in that I need to calculate a rounding to the nearest
\$0.05.  That is if my currency amount is \$2.67, then I need to round down
to \$2.65.  If my currency amount is \$2.68, then I need to round up to
\$2.70.  If my currency amount is \$2.62, then I need to round down to \$2.60,
and if my currency amount is \$2.63, then I need to round up to \$2.65.  Can
anyone help me with the formulae I would need to use?

PPPPPlllllleeeeeaaaaaaasssssseeeeeee????!!!???

--
Posted via CNET Help.com
http://www.*-*-*.com/

Wed, 18 Jun 1902 08:00:00 GMT
Rounding To nearest 05 Cents in Excel 97
=INT(ROUND(A1*20,0))/20

Groeten,

Niek Otten

Quote:
> I have a problem in that I need to calculate a rounding to the nearest
> \$0.05.  That is if my currency amount is \$2.67, then I need to round down
> to \$2.65.  If my currency amount is \$2.68, then I need to round up to
> \$2.70.  If my currency amount is \$2.62, then I need to round down to
\$2.60,
> and if my currency amount is \$2.63, then I need to round up to \$2.65.  Can
> anyone help me with the formulae I would need to use?

> PPPPPlllllleeeeeaaaaaaasssssseeeeeee????!!!???

> --
> Posted via CNET Help.com
> http://www.help.com/

Wed, 18 Jun 1902 08:00:00 GMT
Rounding To nearest 05 Cents in Excel 97
Hello, Try this formula

=Round(2.67/.05,.05)*.05

Good Luck

Quote:

> I have a problem in that I need to calculate a rounding to the nearest
> \$0.05.  That is if my currency amount is \$2.67, then I need to round down
> to \$2.65.  If my currency amount is \$2.68, then I need to round up to
> \$2.70.  If my currency amount is \$2.62, then I need to round down to \$2.60,
> and if my currency amount is \$2.63, then I need to round up to \$2.65.  Can
> anyone help me with the formulae I would need to use?

> PPPPPlllllleeeeeaaaaaaasssssseeeeeee????!!!???

> --
> Posted via CNET Help.com
> http://www.help.com/

Wed, 18 Jun 1902 08:00:00 GMT
Rounding To nearest 05 Cents in Excel 97
Hi Galuys!

Nice maths and logic, but there's a general purpose function that does it!

=MROUND(2.67,0.05) returns 2.65

General Syntax:

=MROUND(PriceToBeRounded,RoundingAmount)

Note that this is in the Analysis Toolpak set of functions and if the
Analysis ToolPak Addin is not in the Tools > Addins dialog box you will need
to re-install Excel and select the Analysis ToolPak option.

As usual functions are faster if there's a lot of them and its general
purpose as far as the rounding amount is concerned. For example, you can
nest an IF or VLOOKUP function in the rounding argument that rounds based
upon the pricetoberounded.

HTH

Sees Ya!

Quote:
> Hello, Try this formula

> =Round(2.67/.05,.05)*.05

> Good Luck

> > I have a problem in that I need to calculate a rounding to the nearest
> > \$0.05.  That is if my currency amount is \$2.67, then I need to round
down
> > to \$2.65.  If my currency amount is \$2.68, then I need to round up to
> > \$2.70.  If my currency amount is \$2.62, then I need to round down to
\$2.60,
> > and if my currency amount is \$2.63, then I need to round up to \$2.65.
Can
> > anyone help me with the formulae I would need to use?

> > PPPPPlllllleeeeeaaaaaaasssssseeeeeee????!!!???

> > --
> > Posted via CNET Help.com
> > http://www.help.com/

Wed, 18 Jun 1902 08:00:00 GMT
Rounding To nearest 05 Cents in Excel 97
Thanks! Was't aware of that one. In my Dutch version of Excel it's called
"AFRONDEN.N.VEELVOUD" you see......

Groeten,

Niek Otten

Quote:
> Hi Galuys!

> Nice maths and logic, but there's a general purpose function that does it!

> =MROUND(2.67,0.05) returns 2.65

> General Syntax:

> =MROUND(PriceToBeRounded,RoundingAmount)

> Note that this is in the Analysis Toolpak set of functions and if the
> Analysis ToolPak Addin is not in the Tools > Addins dialog box you will
need
> to re-install Excel and select the Analysis ToolPak option.

> As usual functions are faster if there's a lot of them and its general
> purpose as far as the rounding amount is concerned. For example, you can
> nest an IF or VLOOKUP function in the rounding argument that rounds based
> upon the pricetoberounded.

> HTH

> Sees Ya!

> > Hello, Try this formula

> > =Round(2.67/.05,.05)*.05

> > Good Luck

> > > I have a problem in that I need to calculate a rounding to the nearest
> > > \$0.05.  That is if my currency amount is \$2.67, then I need to round
> down
> > > to \$2.65.  If my currency amount is \$2.68, then I need to round up to
> > > \$2.70.  If my currency amount is \$2.62, then I need to round down to
> \$2.60,
> > > and if my currency amount is \$2.63, then I need to round up to \$2.65.
> Can
> > > anyone help me with the formulae I would need to use?

> > > PPPPPlllllleeeeeaaaaaaasssssseeeeeee????!!!???

> > > --
> > > Posted via CNET Help.com
> > > http://www.help.com/

Wed, 18 Jun 1902 08:00:00 GMT

 Page 1 of 1 [ 5 post ]

Relevant Pages