VBA IIF Function (Syntax + Example)


- by Puneet

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.


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.