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 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 ﬁnd him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.