I'm trying to figure out how to perform a calculation based on multiple conditions. I have a pre-populated field from a lookup (Employee_Hourly_Rate) that I would like to adjust based on selections in two different sets of radio buttons (Minimum_Hours and Overtime_Type). The field where the calculation takes place is Calculated_Hourly_Rate.

What I want to accomplish is:

If Minimum_Hours=0 (note: Minimum_Hours can be 0, 2, or 3), then calculate Calculated_Hourly_Rate based on these conditions:
Overtime_Type=OT, multiply Employee_Hourly_Rate by 1.5
OR
Overtime_Type=CT, multiply Employee_Hourly_Rate by 1.5
OR/ELSE
Overtime_Type=STR, multiply Employee_Hourly_Rate by 1

If I were only trying to accomplish the overtime piece I would do something like this:

=MULT(Employee_Hourly_Rate,IF(Overtime_Type="OT",1.5,IF(Overtime_Type="CT",1.5,1)))

I'm just not sure how to add the minimum hours piece.

Thank you.