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 36 weeks ago
6 years 22 weeks ago
6 years 34 weeks ago
6 years 37 weeks ago
6 years 38 weeks ago
6 years 43 weeks ago
6 years 52 weeks ago
7 years 2 days ago
7 years 3 days ago
7 years 3 days ago