The Immediate If (IIf) : IIF « Language Basics « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Language Basics
  3. IIF

The Immediate If (IIf)

 
Function EvalSales(curSales As Currency) As String
   EvalSales = IIf(curSales >= 100000, "Great Job", "Keep Plugging")
End Function








Related examples in the same category

1.Use IIF(conditional test, value for True, value for False)
2.Use IIF to calculate value
3.Choosing an Action Using IIf(expr, truepart, falsepart)