Price calculation - rounding
 

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?

Price calculation - rounding
 

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?

Price calculation - rounding
 

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

Price calculation - rounding
 

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?

Price calculation - rounding
 

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

Price calculation - rounding
 

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?

Price calculation - rounding
 

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