Originally Posted by
Mizzou.2018
I need a pretty long formula for all of the following combined ias there are multiple conditions and outcomes.
If A1 is greater than or equal to C1 then return "100% Met" in D1.
If A1 is greater than or equal to 5 points increase than B1 then return "100% Met" in D1. Example 5 points increase would be 90.00 to 95.00.
If A1 is greater than or equal to 3 points increase than B1 then return "50% Met" in D1. Example 3 points increase would be 90.00 to 93.00.
If none of the above are true, then return "Not Met" in D1.
Bookmarks