ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Dividing with Percentage (https://www.excelbanter.com/excel-discussion-misc-queries/161002-dividing-percentage.html)

Jean9

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?

Mike H

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?


Bernard Liengme

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?




Jean9

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