=ROUND(IF(H6>=4.999%,F6*0.04,IF(H6>=4%,F6*0.035,IF(H6>=3%,F6*0.03,IF(H6<=3%,F6*H6)))),2)
Trying to create a formula to calculate the employer retirement match for an employee based on the above formula.
Above is the Excel format.
I want to round to .01,.02,.03,.035, or
.04
The "H6" would be Employee_Deferral_Percentage.
The "F6" would be the Employee_Salary.