Have a look at
http://www.mcgimpsey.com/excel/pennyoff.html
best wishes
--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address
"Jean9" wrote in message
...
My spreadsheet uses 10% against an amount that is received. Once I have
this
figure, sometimes I have to divide if between 3 numbers and end up out a
penny. How can I avoid this problem?