Price calculation - rounding

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I´m doing price calculation in my Excel. I have a problem in rounding the
final figure. I want prices to be rounded up to the next tehth for prices
from 5 and over and lowered to the next tenth for prices 4,99 and under. Can
anyone guide me?
 
Well, that was nothing like what you originally asked, but for your new
question, is there anything wrong with
=ROUND(A1,-1) ?
 

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

Need help in round up or down price to specific ending number 2
rounding up or down 12
Need to increase price by % and rounding up and down 5
Rounding 5
excel formula for markup and profit margin 3
rounding error 2
Rounding up or down 4
Correct format for linking a workbook and a formula 2

Back
Top