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