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