| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation not correct after decresing decimal point
(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) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Decimal point | Excel Discussion (Misc queries) | |||
| Decimal point | New Users to Excel | |||
| Converting 2-place decimal value to floating point decimal number with leading zero | Excel Discussion (Misc queries) | |||
| decimal point | Excel Worksheet Functions | |||
| FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) | |||
Threaded Mode
