IIF Between (two numbers not cells) expression

  • Thread starter Thread starter akelly13
  • Start date Start date
A

akelly13

I want to write a statement that goes something like if [smrhcc] is not null
then " ", if [smrhcc] is between 110 and 160, then pass, else fail. Below is
what I have written so far, why is it passing everything except the null
values in which it leaves blank? Can someone please help me?

IIf(IsNull([smrhcc])," ",IIf(([smrhcc]) isBetween 110< And >160,"pass","fail")
)

Thanks,
Amanda
 
hi Amanda,
IIf(IsNull([smrhcc])," ",IIf(([smrhcc]) isBetween 110< And >160,"pass","fail")
)
Click to expand...
Try this one:

IIf( IsNull([smrhcc]),
" ",
IIf( [smrhcc] BETWEEN 110 AND 160,
"pass",
"fail"
)
)

Remove the line breaksbefore using it.


mfG
--> stefan <--
 
Back
Top