Please give formula and tell me where to post

Fitness Center The manager at a local fitness center has asked you to do some analysis of membership and trainers employed by the fitness center. The Fitness Center worksheet contains records about the members. The manager would like some details about how long they have been members, and how many pay for trainers as part of their membership. He would also like some insights about each of the trainers. Complete the tasks to provide the information to the manager. (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.3 Calculate the "Total with Tax" for Bridget Sexton. - Use the "Tax Rate" in cell O3) in your formula. - Copy and paste the formula down the column to calculate the total with tax for the other members. (1.4 The manager would like to know the number of members assigned to each trainer. In cell P12), use a COUNTIF function to calculate the "\# of Clients" for Sam Crawford. - Reference the trainer name in cell in your function. - Copy and paste across the row to calculate the number of clients for the other trainers. (1.5) The manager would like to know how much in trainer fees was collected for each trainer for members that visited the fitness center 10 or more times in the prior month. In cell P13), calculate the "Revenue 10 or more visits" for Sam Crawford. - Use a SUMIFS function to calculate the revenue from fees for Sam Crawford. - Copy and paste across the row to calculate the fee revenue for 10 or more visits for the other trainers. Fitness Center The manager at a local fitness center has asked you to do some analysis of membership and trainers employed by the fitness center. The Fitness Center worksheet contains records about the members. The manager would like some details about how long they have been members, and how many pay for trainers as part of their membership. He would also like some insights about each of the trainers. Complete the tasks to provide the information to the manager. (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.3 Calculate the "Total with Tax" for Bridget Sexton. - Use the "Tax Rate" in cell O3) in your formula. - Copy and paste the formula down the column to calculate the total with tax for the other members. (1.4 The manager would like to know the number of members assigned to each trainer. In cell P12), use a COUNTIF function to calculate the "\# of Clients" for Sam Crawford. - Reference the trainer name in cell in your function. - Copy and paste across the row to calculate the number of clients for the other trainers. (1.5) The manager would like to know how much in trainer fees was collected for each trainer for members that visited the fitness center 10 or more times in the prior month. In cell P13), calculate the "Revenue 10 or more visits" for Sam Crawford. - Use a SUMIFS function to calculate the revenue from fees for Sam Crawford. - Copy and paste across the row to calculate the fee revenue for 10 or more visits for the other trainers