1.1 Calculate the "Length of (1.2) Calculate the "Monthly Trainer Fee" for Bridget Sexton. - Use an IF function with a nested VLOOKUP to find the appropriate fee based on the trainer assigned to the member. - If there is no trainer assigned the value should be zero (0). - The trainer fee is a one time charge per month. - Copy and paste the formula down the column to calculate the monthly trainer fee for the other members. 1.1 Calculate the "Length of (1.2) Calculate the "Monthly Trainer Fee" for Bridget Sexton. - Use an IF function with a nested VLOOKUP to find the appropriate fee based on the trainer assigned to the member. - If there is no trainer assigned the value should be zero (0). - The trainer fee is a one time charge per month. - Copy and paste the formula down the column to calculate the monthly trainer fee for the other members