IIf funtion based on multiple criteria

  • Thread starter Thread starter Jennifer
  • Start date Start date
J

Jennifer

I have the following expression but want the criteria to include 2 fields:

IIf(IsNull(
),2,1)

If HR is null AND NARC is null I want a 2 otherwise a 1.

Thank you for your help.
 
Jennifer said:
I have the following expression but want the criteria to include 2 fields:

IIf(IsNull(
),2,1)

If HR is null AND NARC is null I want a 2 otherwise a 1.
Click to expand...



IIf(IsNull(
) And IsNull(NARC),2,1)

will do what you asked, but without any context I have no
way of knowing if that's the best way to do it or even if
that is what you need to do.
 
Back
Top