Forum Discussion
Solved
Stringing together formula in Excel to create one formula that looks at multiple factors
Hi, I am trying to write a formula that returns a YES or NO in one cell, based on several different sets of criteria for values in 2 other cells. I know how to write the formula for each differen...
Try
=IF(OR(AND(D10>=1, D10<=31, E10="Days NET"), AND(D10<=30, OR(E10={"Days after receipt","Days after EOM"}))), "YES", "NO")
Try
=IF(OR(AND(D10>=1, D10<=31, E10="Days NET"), AND(D10<=30, OR(E10={"Days after receipt","Days after EOM"}))), "YES", "NO")
This is great thank you! It works great in my worksheet.