=ROUND(F4/100,1)*100

--
Don Guillett
SalesAid Software

"Orninn" wrote in message
...
Let´s take a sample. If I get a price of 1145 or more I want to round up
to
1150 but if price is 1144,99 or lower I want to round down to 1140

"Mike" wrote:

I'm not sure I fully understand what you mean by a tenth but the
following
adds or subtract 1/10 of the value of the cell either up or down

=IF(B6=5,B6+(B6/10),IF(B6<=4.99,B6-(B6/10)))

"Orninn" wrote:

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?