Formula for missing data

[reportit]

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!

[MFGF]

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.