Project Manager Pay based on 2 different rates
I am trying to figure out the best way to calculate monthly Project billing based on 2 different pay rates from 2 Project Managers.
The Project Managers are asked to enter their time for each Project monthly as a % of their total time spent. I have another column that auto calculates that Month's Bill Amount based on that %:
=[January 2022 PM Time]@row * 18286.67
I now need to account for a new Rate of $14404 for the 2nd Project Manager
Based of my Assigned to Column (Lisa =18286.67 and Brand =14404), I need to write formula that will pick the correct Pay Rate.
I'm thinking this can be done with an IF statement, but I can't quite get it to work for me hence my post here.
Thank you in advance for any guidance!!!
Help Article Resources
Check out the Formula Handbook template!