| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculation not correct after decresing decimal point | Excel Discussion (Misc queries) | |||
| How can I convert decimal commas to decimal points? | Excel Discussion (Misc queries) | |||
| decimal points in my spreadsheet | Excel Discussion (Misc queries) | |||
| Formatting Decimal points | Excel Discussion (Misc queries) | |||
| Decimal Points | Excel Worksheet Functions | |||
Threaded Mode
