Salary Increase input both as % and amount in Worksheet
Summary
Salary Increase input both as % and amount in WorksheetContent
Hi,
We are planning to enable the salary increase based on % and amount.
We have made both these fields as editable and updated the formula to enable this.
When the amount is increased, it doesn't increase the % and also goes back to the previous value.
However, updating the %, updates the amount as expected.
Please find below the calculation used:
Increase % |
No Condition:
(Increase Amount/Current Salary) * 100 |
Increase Amount |
Condition : If (Current Salary * Recommended%) != Increase Amount Then (Increase% / 100) * Current Salary
Default: Recommended Amount |
Recommended Amount |
Based on the calculation in worksheet(Non-editable) |
Tagged:
2