iif function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I have written below, my IIF expression which is working perfectly, but i
would like to make an adjustment to it which I cant quite figure out:
=IIf([Score 9mm]>=135/180,"PASS","FAIL")
What I would like to add to this, is if there is no value entered at all,
then I would like it to come up blank, rather than "Fail" like it is doing
currently. It isn't a major problem, but it would make it look mor
professional.
Any help would be greatly appreciated, thank you!

Rigby
 
rigby said:
Hi
I have written below, my IIF expression which is working perfectly, but i
would like to make an adjustment to it which I cant quite figure out:
=IIf([Score 9mm]>=135/180,"PASS","FAIL")
What I would like to add to this, is if there is no value entered at all,
then I would like it to come up blank, rather than "Fail" like it is doing
currently. It isn't a major problem, but it would make it look mor
professional.
Any help would be greatly appreciated, thank you!

Rigby
Click to expand...


You can try

iif(isnull([Score 9mm]),"",IIf([Score 9mm]>=135/180,"PASS","FAIL"))

thnx
Pradeep
 
rigby said:
Hi
I have written below, my IIF expression which is working perfectly, but i
would like to make an adjustment to it which I cant quite figure out:
=IIf([Score 9mm]>=135/180,"PASS","FAIL")
What I would like to add to this, is if there is no value entered at all,
then I would like it to come up blank, rather than "Fail" like it is doing
currently. It isn't a major problem, but it would make it look mor
professional.
Any help would be greatly appreciated, thank you!

Rigby
Click to expand...

Wrap your existing evaluation in another in-line 'if' (untested):

IIf(IsNull([Score 9mm]),Null,IIf([Score 9mm]>=135/180,"PASS","FAIL"))

HTH - Keith.
www.keithwilby.com
 
Back
Top