Looking for help with writing an "IF" statement that will look for specific text with multiple rows and returning a "YES" or "NO" result. Here is what I have: =IF(N2:CT2="X5M"OR"15M","YES","NO"). I'm lost in the sauce. Thanks.
Mon, 08/03/2015 - 07:33
#1
USING "IF" STATEMENTS
I'm trying to use IF function to show "Not Compliant" if any from row D3 to D26 has a date < Today.
I tried using this =IF(D3:D26<TODAY, "NON COMPLIANT", "COMPLIANT"), and got a #Value result. Please help.
Add new comment