RE: Can I round prices to end in .95?

From: JBeaucaire <jbeau@xxxxxxxxxxxxxxxxxxxxxx>
Date: Tue, 13 Jan 2009 14:47:02 -0800

You don't really give enough info, so I will assume you want whatever price
is in cell A1 to round to the NEAREST X.95. That formula would be:

=ROUND(A1,0)-0.05

To always round UP to the next X.95, try:

=CEILING(A1,1)-0.05

--
"Actually, I AM a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.

"Tire Guy" wrote:

I'm preparing a business price list. It reads a cell from my working cost
sheets.
On the price page can I round prices to end in .95?

References:
- Can I round prices to end in .95?
  - From: Tire Guy

Prev by Date: Re: Operations with conditional formatting
Next by Date: sumif
Previous by thread: RE: Can I round prices to end in .95?
Next by thread: #Value! error when evaluating data in a cell range
Index(es):
- Date
- Thread