Calculation difference after decresing decimal points
 

(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

Calculation difference after decresing decimal points
 

Are you rounding to 2 dec places as you go, at the end, or at all?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Imran" wrote in message
...
(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