I have various prices / 5.26, 2.14, 16.58 that I want to round up to the next
..95 so they will be 5.95, 2.95, 16.95. Is there an automated way to do this?
Thank you.
--
MikeB94518

Hi, Mike. I always do it this way: Round up to the nearest dollar, then
subtract a nickel. Like:

=roundup(a1,0)-.05
*******************
~Anne Troy

www.OfficeArticles.com



"MikeB94518" wrote in message
...
I have various prices / 5.26, 2.14, 16.58 that I want to round up to the
next
.95 so they will be 5.95, 2.95, 16.95. Is there an automated way to do
this?
Thank you.
--
MikeB94518

one way?
=INT(C12)+1-0.05

--
Don Guillett
SalesAid Software

"MikeB94518" wrote in message
...
I have various prices / 5.26, 2.14, 16.58 that I want to round up to the
next
.95 so they will be 5.95, 2.95, 16.95. Is there an automated way to do
this?
Thank you.
--
MikeB94518

=INT(A1)+0.95+(MOD(A1,1)0.95)
hence 1.96 will become 2.95 ; the next round up number ending in .95
if you want it to be 1.95 instead simply remove the mod part of the formula


"MikeB94518" wrote in message
...
I have various prices / 5.26, 2.14, 16.58 that I want to round up to the
next
.95 so they will be 5.95, 2.95, 16.95. Is there an automated way to do
this?
Thank you.
--
MikeB94518

Thank you. So, if my price of 10.45 is in cell b5 (coming from a formula
a5*1.5), and I want it to go to 10.95, how do I do the formula? would it
be =b5........?
Thank you
--
MikeB94518


"Anne Troy" wrote:

Hi, Mike. I always do it this way: Round up to the nearest dollar, then
subtract a nickel. Like:

=roundup(a1,0)-.05
*******************
~Anne Troy

www.OfficeArticles.com



"MikeB94518" wrote in message
...
I have various prices / 5.26, 2.14, 16.58 that I want to round up to the
next
.95 so they will be 5.95, 2.95, 16.95. Is there an automated way to do
this?
Thank you.
--
MikeB94518

thank you. If my number 10.45 is in cell b5, coming from a formula b4*1.5,
how do I do the formula? =b5.....?
thank you
--
MikeB94518


"Don Guillett" wrote:

one way?
=INT(C12)+1-0.05

--
Don Guillett
SalesAid Software

"MikeB94518" wrote in message
...
I have various prices / 5.26, 2.14, 16.58 that I want to round up to the
next
.95 so they will be 5.95, 2.95, 16.95. Is there an automated way to do
this?
Thank you.
--
MikeB94518

As usual, better than mine.
How are things "down under"?

--
Don Guillett
SalesAid Software

"N Harkawat" <nharkawat@hotmail_dot_com wrote in message
...
=INT(A1)+0.95+(MOD(A1,1)0.95)
hence 1.96 will become 2.95 ; the next round up number ending in .95
if you want it to be 1.95 instead simply remove the mod part of the
formula


"MikeB94518" wrote in message
...
I have various prices / 5.26, 2.14, 16.58 that I want to round up to the
next
.95 so they will be 5.95, 2.95, 16.95. Is there an automated way to do
this?
Thank you.
--
MikeB94518

Don,
No not "Down under" I am from NJ and try sneaking in once in a while at
this newsgroup here at work, trying to hone my excel skills


"Don Guillett" wrote in message
...
As usual, better than mine.
How are things "down under"?

--
Don Guillett
SalesAid Software

"N Harkawat" <nharkawat@hotmail_dot_com wrote in message
...
=INT(A1)+0.95+(MOD(A1,1)0.95)
hence 1.96 will become 2.95 ; the next round up number ending in .95
if you want it to be 1.95 instead simply remove the mod part of the
formula


"MikeB94518" wrote in message
...
I have various prices / 5.26, 2.14, 16.58 that I want to round up to the
next
.95 so they will be 5.95, 2.95, 16.95. Is there an automated way to do
this?
Thank you.
--
MikeB94518

Mike, seems everyone thinks you should know what to do to incorporate their
suggestions into your formula.<g

If B5 contains the formula:

=B4*1.5

Then, depending on whose suggestion you care to use, try either of these in
B5:

=ROUNDUP(B4*1.5,0)-.05

=INT(B4*1.5)+1-0.05

=INT(B4*1.5)+0.95+(MOD(B4*1.5,1)0.95)

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"MikeB94518" wrote in message
...
thank you. If my number 10.45 is in cell b5, coming from a formula
b4*1.5,
how do I do the formula? =b5.....?
thank you
--
MikeB94518


"Don Guillett" wrote:

one way?
=INT(C12)+1-0.05

--
Don Guillett
SalesAid Software

"MikeB94518" wrote in message
...
I have various prices / 5.26, 2.14, 16.58 that I want to round up to
the
next
.95 so they will be 5.95, 2.95, 16.95. Is there an automated way to
do
this?
Thank you.
--
MikeB94518

Well...some of us from PA might call NJ "down under". ROFL!!
*******************
~Anne Troy

www.OfficeArticles.com


"N Harkawat" <nharkawat@hotmail_dot_com wrote in message
...
Don,
No not "Down under" I am from NJ and try sneaking in once in a while at
this newsgroup here at work, trying to hone my excel skills


"Don Guillett" wrote in message
...
As usual, better than mine.
How are things "down under"?

--
Don Guillett
SalesAid Software

"N Harkawat" <nharkawat@hotmail_dot_com wrote in message
...
=INT(A1)+0.95+(MOD(A1,1)0.95)
hence 1.96 will become 2.95 ; the next round up number ending in .95
if you want it to be 1.95 instead simply remove the mod part of the
formula


"MikeB94518" wrote in message
...
I have various prices / 5.26, 2.14, 16.58 that I want to round up to
the
next
.95 so they will be 5.95, 2.95, 16.95. Is there an automated way to
do
this?
Thank you.
--
MikeB94518

Sorry, Had you confused with someone else. For you, TEXAS (where I am), is
"down under"

--
Don Guillett
SalesAid Software

"N Harkawat" <nharkawat@hotmail_dot_com wrote in message
...
Don,
No not "Down under" I am from NJ and try sneaking in once in a while at
this newsgroup here at work, trying to hone my excel skills


"Don Guillett" wrote in message
...
As usual, better than mine.
How are things "down under"?

--
Don Guillett
SalesAid Software

"N Harkawat" <nharkawat@hotmail_dot_com wrote in message
...
=INT(A1)+0.95+(MOD(A1,1)0.95)
hence 1.96 will become 2.95 ; the next round up number ending in .95
if you want it to be 1.95 instead simply remove the mod part of the
formula


"MikeB94518" wrote in message
...
I have various prices / 5.26, 2.14, 16.58 that I want to round up to
the
next
.95 so they will be 5.95, 2.95, 16.95. Is there an automated way to
do
this?
Thank you.
--
MikeB94518