Pricing - how to round up various prices to .95

M

MikeB94518

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.
 
N

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
 
M

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
 
M

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
 
N

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
 
R

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

Anne Troy

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

www.OfficeArticles.com


N Harkawat said:
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
Click to expand...
 
D

Don Guillett

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

--
Don Guillett
SalesAid Software
[email protected]
N Harkawat said:
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
Click to expand...
 
Top