You want to calculate agent commissions based on their role.In cell K$12,$ insert the IFS function to calculate the agent's commission based on the agent code and the applicable rates in the range L$2$:L$4.$ Use relative and mixed references correctly.Copy the function to the range K$13$:K$39.$