![]() |
Dividing with Percentage
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? |
Dividing with Percentage
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? |
Dividing with Percentage
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? |
Dividing with Percentage
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? |
All times are GMT +1. The time now is 01:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com