Hi, Need help to get a formula in excel for the same. If a course director/ course faculty (will be a drop down list) who is of a particular category (will be a drop down list) visits the center for either full day/ half day / per hour /absent (will be a drop down list) than what will be his fees(need to reflect in the final answer column. Fees Cadre Full Day Half Day Per Hour Absent Course Director Category A 1,20,000.00 60,000.00 Course Director Category B 1,00,000.00 50,000.00 Course Director Category C 50,000.00 25,000.00 Course Faculty Category A 20,000.00 10,000.00 2,500.00
Solved by E. F. in 26 mins