Price calculation - rounding

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

Similar Threads

Rounding off to .48 or .98 9
Complex value lookup? (Excel 2003) 6
Rounding 5
Round up to the next number in the set 7
Need Macro... 8
Apple's price hike 7
Round price to end in .99 5
Calculation based on lowest price 6

Top