Have a ook at this:-

http://www.mcgimpsey.com/excel/pennyoff.html

Mike

"Jean9" wrote:

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?