Can I round prices to end in .95?

T

Tire Guy

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?
 
J

JBeaucaire

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

rounding a number up to a certain ending digit 6
Percentage Increase 11
Need formula to round number up to always end in X.X9 6
IF and Round 5
Formula to round off number to .95 cents 3
Word VBA - Automatic change content of a cell in table using dropdown list 5
Help on randomly selecting cells to SUM 2
Nested Formulas v Named Formulas Any other solutions? 10

Top