What is the formula for rounding a dollar amount to the nearest nickel?

Didn't make sense... I meant cents rounding to nearest nickle,Example: 1.22 =
1.20 or 1.23 = 1.25. ;-)

"JeriSys" wrote:

What is the formula for rounding a dollar amount to the nearest nickel?

Try this:
For a value in A1
B1: =ROUND(A1/0.05,0)*0.05

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"JeriSys" wrote:

Didn't make sense... I meant cents rounding to nearest nickle,Example: 1.22 =
1.20 or 1.23 = 1.25. ;-)

"JeriSys" wrote:

What is the formula for rounding a dollar amount to the nearest nickel?

Ya know what? Between reading some posts, and installing something called an
Analysis Toolpak, it worked out! Should have delved in a little deeper
before asking. Thank you, though!!

"Ron Coderre" wrote:

Try this:
For a value in A1
B1: =ROUND(A1/0.05,0)*0.05

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"JeriSys" wrote:

Didn't make sense... I meant cents rounding to nearest nickle,Example: 1.22 =
1.20 or 1.23 = 1.25. ;-)

"JeriSys" wrote:

What is the formula for rounding a dollar amount to the nearest nickel?

The Analysis Tool Pak (ATP) in an add-in that provides dozens of
addition functions. If you have the ATP loaded (go to the Tools
menu, choose Add-Ins, and put a check next to Analysis Tool Pak),
you can use the MROUND function to round to the nearest nickel.

=MROUND(A1,0.05)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"JeriSys" wrote in message
...
Ya know what? Between reading some posts, and installing
something called an
Analysis Toolpak, it worked out! Should have delved in a
little deeper
before asking. Thank you, though!!

"Ron Coderre" wrote:

Try this:
For a value in A1
B1: =ROUND(A1/0.05,0)*0.05

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"JeriSys" wrote:

Didn't make sense... I meant cents rounding to nearest
nickle,Example: 1.22 =
1.20 or 1.23 = 1.25. ;-)

"JeriSys" wrote:

What is the formula for rounding a dollar amount to the
nearest nickel?

That's exactly what I did... as you descibed below. Works great!!

"Chip Pearson" wrote:

The Analysis Tool Pak (ATP) in an add-in that provides dozens of
addition functions. If you have the ATP loaded (go to the Tools
menu, choose Add-Ins, and put a check next to Analysis Tool Pak),
you can use the MROUND function to round to the nearest nickel.

=MROUND(A1,0.05)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"JeriSys" wrote in message
...
Ya know what? Between reading some posts, and installing
something called an
Analysis Toolpak, it worked out! Should have delved in a
little deeper
before asking. Thank you, though!!

"Ron Coderre" wrote:

Try this:
For a value in A1
B1: =ROUND(A1/0.05,0)*0.05

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"JeriSys" wrote:

Didn't make sense... I meant cents rounding to nearest
nickle,Example: 1.22 =
1.20 or 1.23 = 1.25. ;-)

"JeriSys" wrote:

What is the formula for rounding a dollar amount to the
nearest nickel?