Nested IF Statement

[AliGeeJay]

I am looking for some advice of nested IF statements.

I am looking to put an IF statement in Cell C2 with the following conditions:

If Cell A2 <10 and Cell D2 = Compliant then “ “ but, if Cell A2 is between 10 and 50 refence Cell E5, but if it is >50 then reference Cell E4.

However if Cell A2 <10 and Cell D2 = Investigate then reference Cell E3 but, if Cell A2 is between 10 and 50 reference Cell E5, but if it is >50 then reference Cell E4.

Finally, if Cell D2 = Concurrent then reference Cell E4.

I hope my outline above makes sense.

I have attached a spreadsheet for reference of what the outcome would look like.

Con_Sample.xlsx
	A	B	C	D	E
1	Threshold %			RAG Status
2	9	%		Compliant
3	35	%	✅	Compliant	?
4	-12	%	?	Investigate	✅
5	15	%	⚠	Concurrent	⚠
Sheet1

Cell Formulas
Range	Formula
C5	C5	=IF(A5<0,"",IF(OR(D5="Concurrent",D5="Investigate",D5="Compliant"),IF(OR(A5>10,A5<50,),E5,"")))

 

[6StringJazzer]

Agreed, I was just going by the description. Have to see if there is any further feedback from the OP.

Having the same problem in the cross-posted thread.