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?

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?

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?

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

Well, that was nothing like what you originally asked, but for your new
question, is there anything wrong with
=ROUND(A1,-1) ?
--
David Biddulph

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

=ROUND(A1,-1) is the solution.
Thanks a lot!

"David Biddulph" wrote:

Well, that was nothing like what you originally asked, but for your new
question, is there anything wrong with
=ROUND(A1,-1) ?
--
David Biddulph

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

=IF(A1<5,ROUNDDOWN(A1,1),ROUNDUP(A1,1))
--
David Biddulph

"Orninn" wrote in message
...
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?