Error:The first input should be a condition that returns true or false

[TheArcCalhoun]

I am trying to create a formula for a report that will essentially go to a child table, look for a certain screening, and if it is required, return the Expiration Date of the screening. If the screening is not required, I would like it to just return N/A. I figured the formula would be something along the lines of...

<<IF(

SELECT(Screenings[Screenings ID], AND([Screenings ID]=[_THISROW].[Screenings ID],[Screening]=“OIG Exclusion”, [REQUIRED]=”TRUE”)),

(Screenings.[Expiration Date]),

“N/A”)>>

but I am getting the error "is invalid due to: IF function is used incorrectly: the first input should be a condition that returns true or false." Any thoughts on what I am missing?

[Swoopy]

IF(
   SELECT(Screenings[Screenings ID],
      AND(
         [Screenings ID]=[_THISROW].[Screenings ID],
         [Screening]=“OIG Exclusion”,
         [REQUIRED]=TRUE
      )
   ) = ?...required for condition of true...? ,
   [Screenings].[Expiration Date],
   “N/A”
)