Hello,
I'm not really experienced with excel formulas, and I was hoping someone help find out where I'm going wrong. What I am trying to do is if the three cells C4, H4 and I4, have met the conditions, I would like to apply a value into a cell new cell depending on the value in L28. I have a long list and the value in L28 can differ in value between 1 to over 365.
=IF(OR($C4="Inactive", $H4="NO",I4="YES"),0,IF(OR($L28<90,$M$6),IF(OR(L28>90,L28<180),$O$6),IF(OR(L28>181,L28<365),$O$6),IF(L28>365,$P$6))
I'm not really experienced with excel formulas, and I was hoping someone help find out where I'm going wrong. What I am trying to do is if the three cells C4, H4 and I4, have met the conditions, I would like to apply a value into a cell new cell depending on the value in L28. I have a long list and the value in L28 can differ in value between 1 to over 365.
=IF(OR($C4="Inactive", $H4="NO",I4="YES"),0,IF(OR($L28<90,$M$6),IF(OR(L28>90,L28<180),$O$6),IF(OR(L28>181,L28<365),$O$6),IF(L28>365,$P$6))