There are two criteria where I am unable to write a formula and
need help. I want to update the Payout column with a formula
based on number of hours worked by the employee and also based
on their role/designation. Need formulas in range E11:E20
My attempt and posted it at
http://zvkmpw.home.comcast.net/Payment_calculation.xls
The worksheet includes an explanation of how the calculation works.
Check that it gets the results you expect.
Hope this helps getting started.