Multiple IF functions with multiple conditions

[RJB78]

Hello -

Problem: I am trying to get a formula to display the letter "G", "D", or "GI" based on the values of two other cells.

Example:

Symbol G,D,GI % Yes/No
A G 0.25% Y
B G 5.00% N
C G 3.00% #N/A
D D 4.00% Y
E GI 2.50% Y

Rules:

G = If Yes/No column = #N/A, then I want the G,D,GI column to display the letter 'G'. (The #N/A is from a vlookup not finding a value)
If Yes/No column = N, then I want the G,D,GI column to display the letter 'G'
If Yes/No column = Y, Then I want the G,D,GI column to display the letter 'G', only if the percentage in the % column is greater than or equal to 0 and less than .005 (between 0 and .049(mutual exclusivity))

GI = If Yes/No column = Y, then I want the G,D,GI column to display the letters 'GI', only if the percentage in the % column is greater than or equal to .005 and less than .04 (between .005 and .039)(mutual exclusivity))

D = If Yes/No column= Y, then I want the G,D,GI column to display the letter 'D', only if the percentage in the % column is greater than or equal to .04

I have some individual formulas for some of the rules, but I am not sure how to do the formula for the "G" '#N/A' rule and combine them all the rule formulas to work together.

"G" 'N' Rule: =IF(D2="N","G")
"G" 'Y' Rule: =IF(AND(D2="Y",C2>=0,C2<.005),"G")

GI Rule: =IF(AND(D2="Y",C2>=.005,C2<0.04),"GI")

D Rule: = IF(AND(D2="Y",C2>=.04),"D")

If there is no solution for the "G" 'N/A' rule I suppose I could use the iferror function to return a 'N/A'. Correct?


Thank you in advance, I really appreciate any and all assistance.

 

[RJB78]

I also used a =iferror on the vlookup to give back the text "N/A" if the formula results in an error(#N/A). The original formula you gave me works perfectly using that

 

[oldbrewer]

we crossed in the post - use ISNA