VBA IFF Function

HomeVBA Functions LIST (Category Wise)How to use the VBA IIF Function (Syntax + Example)

What is VBA IFF Function

how to use it

To use VBA's IFF function you need to understand its syntax and arguments:


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.

About the Author

puneet one point one

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.