IIF Between (two numbers not cells) expression

[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

 

[Stefan Hoffmann]

hi Amanda,

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

Try this one:

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

Remove the line breaksbefore using it.


mfG
--> stefan <--

 

[Guest]

Try

IIf([smrhcc] between 110 and 160, "Pass",IIf([smrhcc] < 110,"Fail"," "))