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