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?