Returning a YES value

Debbie Petersen

Trying to get a formula to evaluate 2 columns and if the 1st column is CURRENT and the 2nd Column is CHECKED, return a value of YES, and if either column doesn't show the CURRENT of CHECKED, return a value of NO.  Have tried many combos and think I'm close  - what's missing or wrong here:

 

=IF(AND([Ins Status]@row = "Current", [Agreement EXE]@row 1), YES, NO)

Included a snip.  THANKS!!

L_123

=IF(AND([Ins Status]@row = "Current", [Agreement EXE]@row = 1), "YES", "NO")

 

Just missing an equal sign and some quotes

Debbie Petersen

AHH!  Thank you so much!