I need a formula that will show 'YES' if the employee is in the status of 'Full Time' does not have a Benefit plan of 'Medical', otherwise the cell needs to be blank.
I tried but it didn't work:
IF (([Status] in ('Full Time')) and (([Benefit Plan]='Medical') is missing)) then ('YES') else Null
Does anyone have any idea of a formula that would do what I need?
Thanks!
Quote from: reportit on 25 Apr 2017 05:04:57 PM
I need a formula that will show 'YES' if the employee is in the status of 'Full Time' does not have a Benefit plan of 'Medical', otherwise the cell needs to be blank.
I tried but it didn't work:
IF (([Status] in ('Full Time')) and (([Benefit Plan]='Medical') is missing)) then ('YES') else Null
Does anyone have any idea of a formula that would do what I need?
Thanks!
How about:
IF ([Status] = 'Full Time' and [Benefit Plan] <> 'Medical') then ('YES') else (Null)
MF.