Price calculation - rounding

O

Orninn

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

David Biddulph

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

Top