VBA IIF Function (Syntax + Example)

HomeVBA TutorialTop VBA FunctionsVBA IIF Function (Syntax + Example)

The VBA IFF function is listed under the logical category of VBA functions. When you use it in a VBA code, it evaluates the value supplied for a condition and returns a value is the condition is TRUE else the other value if that condition is FALSE. It’s just like the IF function in the worksheet.

Table of Content Close


IIf(Expression, TruePart, FalsePart)


  • Expression: The condition which you want to test.
  • TruePart: The value to return if “Expression” is TRUE.
  • FalsePart: The value to return if “Expression” is FALSE.

It’s better to use VBA IF statement instead of IIF as it makes code hard to read.