(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

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" <(E-Mail Removed)> wrote in message
news:6761C7DD-8180-43B4-860E-(E-Mail Removed)...
> (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
>
>