What is the easiest way to round the results of the calculations to the
whole 5 cents i.e. 5.22 will result in 5.20, 5.24 in 5.25, 5.27 in 5.25,
5.28 in 5.30 etc.

Thanks for any suggestions.

Tony

Did you try the archives? or google?

--
Don Guillett
SalesAid Software
Granite Shoals, TX

"Tony" wrote in message
...
What is the easiest way to round the results of the calculations to the
whole 5 cents i.e. 5.22 will result in 5.20, 5.24 in 5.25, 5.27 in 5.25,
5.28 in 5.30 etc.

Thanks for any suggestions.

Tony

Don,

Thanks a lot for you informative, intelligent and insightful response to Tony's question!!!
With your excellent suggestions, we can close down the newsgroups all together, and
just use "google".

Many of us come here to get the personal attention from the many experts who come
here to assist those of us who are beginners, laymen, or in some cases, experts who also
need help.

I appologize to Tony for your inconsiderate and uninformed response to his question.

Bernie


On Tue, 29 Jul 2003 07:12:43 -0500, "Don Guillett" wrote:
Did you try the archives? or google?

--
Don Guillett
SalesAid Software
Granite Shoals, TX

"Tony" wrote in message
...
What is the easiest way to round the results of the calculations to the
whole 5 cents i.e. 5.22 will result in 5.20, 5.24 in 5.25, 5.27 in 5.25,
5.28 in 5.30 etc.

Thanks for any suggestions.

Tony

Tony,

Try the MROUND function. E.g.,
=MROUND(A1,0.25)

See Help for more details.

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



"Tony" wrote in message
...
What is the easiest way to round the results of the calculations
to the
whole 5 cents i.e. 5.22 will result in 5.20, 5.24 in 5.25, 5.27
in 5.25,
5.28 in 5.30 etc.

Thanks for any suggestions.

Tony

I think Chip meant:

=MROUND(A1,0.05)

and if you haven't got MROUND, you'll find it in the Analysis Toolpak
add-in. Without the add-in, one possibility:

=0.05*INT((A1+.025)/.05)


"Chip Pearson" wrote in message
...
Tony,

Try the MROUND function. E.g.,
=MROUND(A1,0.25)

See Help for more details.

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



"Tony" wrote in message
...
What is the easiest way to round the results of the calculations
to the
whole 5 cents i.e. 5.22 will result in 5.20, 5.24 in 5.25, 5.27
in 5.25,
5.28 in 5.30 etc.

Thanks for any suggestions.

Tony

Tony,

Try the following link

http://j-walk.com/ss/excel/files/cellmath.htm.

I have found great use for this free utility from John
Walkenbach's excellent website.

Regards,

Mike


-----Original Message-----
What is the easiest way to round the results of the
calculations to the
whole 5 cents i.e. 5.22 will result in 5.20, 5.24 in
5.25, 5.27 in 5.25,
5.28 in 5.30 etc.

Thanks for any suggestions.

Tony


.

Check out the CEILING worksheet function.

From the Help file:
Returns number rounded up, away from zero, to the nearest
multiple of significance. For example, if you want to avoid
using pennies in your prices and your product is priced at
$4.42, use the formula =CEILING(4.42,0.05) to round prices
up to the nearest nickel.

Hope this helps,
James dot Becker at NCR dot com
~
~
~
:wq!

"Tony" wrote in message
...
What is the easiest way to round the results of the calculations to the
whole 5 cents i.e. 5.22 will result in 5.20, 5.24 in 5.25, 5.27 in 5.25,
5.28 in 5.30 etc.

Thanks for any suggestions.

Tony