I am trying to get an IF statement containing four conditions to result in one answer (or blank).
Here is my formula:
=IF($L2=1,IF(AND($H2>=50,$O2>=5,$O2<8),"A: Priority 2",""))
Maybe:
=IF($L2=1,IF(AND($H2>=50,$O2>=5,$O2<8),"A: Priority 2",""),"")