I need two formulas that read the values in column D compare it to column G and H. Based on the outcome column I would say “100% Met” or “50% Met” or “Not Met”.
First Formula Rules:
To achieve "100 % Met" the values in column D have to be greater than or equal to the values in columns G
To achieve "100 % Met" the values in column D have to be 5 percentage points (90.00% to 95.00%) greater than or equal to the values in column H
To achieve "50 % Met" the values in column D have to be 3 percentage points (90.00% to 93.00%) greater than or equal to the values in column H
If not "100% Met" or "50% Met" then the cell in column I should read "Not Met"
Second Formula Rules:
To achieve "100 % Met" the values in column D have to be less than or equal to the values in columns G
To achieve "100 % Met" the values in column D have to be 5 percentage points (90.00% to 85.00%) less than or equal to the values in column H
To achieve "50 % Met" the values in column D have to be 3 percentage points (90.00% to 87.00%) less than or equal to the values in column H
If not "100% Met" or "50% Met" then the cell in column I should read "Not Met"
Needed Formulas to show "100% Met" or "50% Met" or "Not Met" in column I.
One formula showing greater than or equal to G# or 3 percentage points greater than or equal to H# or 5 percentage points greater than or equal to H#. Increased 3 percentage points but not 5 then it's "50% Met". Increased 5 percentage points or more then it's "100% Met"
Another formula showing less than or equal to G# or 3 percentage points less than or equal to H# or 5 percentage poitns less than or equal to H#. Decreased 3 percentage points but not 5 then it's "50% Met". Decreased 5 percentage poitns or more then it's "100% Met"
Note: Percentage points NOT 3 or 5 percentage of value. Example: 90.00% to 95.00% would get "100% Met" or inversed 98.00% to 95.00% would get "50% Met".
Bookmarks