iif question

  • Thread starter Thread starter KL
  • Start date Start date
K

KL

I got 3 conditions that I need to use the "iif"
Expression. I am not sure where I should put the 3rd
condtion. e.g. iif(count=1, "Good", "Bad") where sould
I put the "OK".
 
The IIF statement only has 2 conditions, true or false. In order to have a
3rd condition you would need nested IIF statement. In your example if count
equals 1 then "Good" is displayed otherwise "Bad" is displayed. What would
trigger "OK"? The following assumes a count of 2 will trigger OK.

IIF(Count=1,"Good",IIF(Count=2,"OK","Bad"))

Kelvin
 
Back
Top