IF Formula Assistance
I currently have an If formula that reads like the image below.
I'm wondering if it's possible to say: that IF the Actual $, is doubled from the goal, then M14 would be doubled. I would rather use a formula for Actuals being doubled from the goal, in case the Goal #'s change in the future.
Currently, if the salesman does not meet their week 1 goal, it subtracts half of M14. Same with week #2. The entire section is worth 20% (as a pay deduction), but I would like to be able to say that it could go so far as a 20% extra credit if they double their weekly goals.
Is it a nested If statement? Or? And?
Thank you in advance!!!
Recent comments
5 years 42 weeks ago
6 years 28 weeks ago
6 years 40 weeks ago
6 years 42 weeks ago
6 years 43 weeks ago
6 years 49 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago