View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Calculation not correct after decresing decimal point

Have a look he

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

Hope this helps.

Pete

On Jun 24, 6:52*am, Imran wrote:
(1) * * Basic Salary Per Month *103,404
(2) * * Social Charges (21%of 1) * * * *21,715
(3) * * Overhead *(90% of 1) * * * * * *93,064
(4) * * Sub-Total (1+2+3) * * * * * * * 218,182
(5) * * Fee(10% of 4) * * * * * 21,818
(6) * * Rate Project Office * * * * * * 240,001
(7) * * Field Allowance (10% of 1) * * *10,340
(8) * * Rate per month for Field Work * 250,341

I calculate the above salary sheet with formula but in S.No. 4 & 8 the total
is not match with figures when I decreased the decimal point to Zero (See
Above). Is there any formula in excel which correct this problem
Note: (Please calculate all that values in excle and u will find the
problem, whome i face)