mart_mrexcel
Active Member
- Joined
- Aug 23, 2008
- Messages
- 310
- Office Version
- 365
- Platform
- Windows
- End user is giving a manual Total Salary, then
- The “Accommodation”, “Car Allowance” and “Basic” should automatically calculate based on the given formula as displayed in D3,E3,F4. How can i satisfy the formula equal to the variable that is entered manuall?
Book1 | |||||||
---|---|---|---|---|---|---|---|
B | C | D | E | F | |||
2 | |||||||
3 | This is Manual Entry ¤ | 25% Of the Basic min 3,333 ¤ | 10% of the Basic Max 1,500 ¤ | This is the Remaing Total of "Total Salary" minus the Accomodation & Car Allowance ¤ | |||
4 | Worker | Total Salary | Accomodation | Car Allow | Basic | ||
5 | Emp 1 | 22,000.00 | |||||
Sheet1 |