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

Similar Threads

Turning off automatic calculation 0
Sale options on a CSV 1
rounding a number up to a certain ending digit 6
Complex value lookup? (Excel 2003) 6
Trying to reference two sets of data with one number 1
Round price to end in .99 5
help on summing a random combination 1
Rounding off to .48 or .98 9

Top