Pricing - how to round up various prices to .95

[Guest]

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.

 

[Anne Troy]

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

 

[Don Guillett]

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

 

[N Harkawat]

=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

 

[Guest]

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

 

[Guest]

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

 

[Don Guillett]

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

 

[N Harkawat]

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

 

[RagDyer]

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

 

[Anne Troy]

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

www.OfficeArticles.com

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]

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

--
Don Guillett
SalesAid Software
(e-mail address removed)

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