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?

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?

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?

Hi Mike,

I checked out the info that you suggested and now the worksheet works
wonderfully.

Thks,

Jean9

"Mike H" wrote:

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?