2 Formulas Needed to Read Values and input "100% Met", "50% Met" or "Not Met"

[Mizzou_2018]

I need two formulas that read the values in column D compareit 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 haveto be greater than or equal to the values in columns G

To achieve "100 % Met" the values in column D haveto be 5 percentage points (90.00% to 95.00%) greater than or equal to thevalues in column H

To achieve "50 % Met" the values in column D haveto be 3 percentage points (90.00% to 93.00%) greater than or equal to thevalues in column H

If not "100% Met" or "50% Met" then thecell in column I should read "Not Met"


Second Formula Rules:
To achieve "100 % Met" the values in column D haveto be less than or equal to the values in columns G

To achieve "100 % Met" the values in column D haveto be 5 percentage points (90.00% to 85.00%) less than or equal to the valuesin column H

To achieve "50 % Met" the values in column D haveto be 3 percentage points (90.00% to 87.00%) less than or equal to the valuesin column H

If not "100% Met" or "50% Met" then thecell 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 3percentage points greater than or equal to H# or 5 percentage points greaterthan 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 3percentage points less than or equal to H# or 5 percentage poitns less than orequal 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: Percentagepoints 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".