IIf Function
āĻŽā§āĻ˛ā§āĻ¯āĻžā§āĻ¨āĻāĻāĻ¤ āĻāĻā§āĻ¸āĻĒā§āĻ°ā§āĻļāĻ¨ā§āĻ° āĻ˛āĻāĻŋāĻā§āĻ¯āĻžāĻ˛ āĻŽāĻžāĻ¨ā§āĻ° āĻāĻĒāĻ° āĻ¨āĻŋāĻ°ā§āĻŦāĻ°āĻļā§āĻ˛ āĻĻā§āĻāĻāĻŋ āĻ¸āĻŽā§āĻāĻžāĻŦā§āĻ¯ āĻĢāĻžāĻāĻļāĻ¨ āĻĢāĻ˛āĻžāĻĢāĻ˛ā§āĻ° āĻŽāĻ§ā§āĻ¯ā§ āĻāĻāĻāĻŋ āĻĒā§āĻ°āĻĻāĻžāĻ¨ āĻāĻ°ā§ āĻĨāĻžāĻā§āĨ¤
IIf (Expression, ExpressionTrue, ExpressionFalse)
āĻāĻā§āĻ¸āĻĒā§āĻ°ā§āĻļāĻ¨: āĻ¯ā§āĻā§āĻ¨ā§ āĻāĻā§āĻ¸āĻĒā§āĻ°ā§āĻļāĻ¨ āĻāĻĒāĻ¨āĻŋ āĻ¯āĻž āĻŽā§āĻ˛ā§āĻ¯āĻžā§āĻ¨ āĻāĻ°āĻ¤ā§ āĻāĻžāĻ¨āĨ¤ āĻ¯āĻĻāĻŋ āĻāĻā§āĻ¸āĻĒā§āĻ°ā§āĻļāĻ¨āĻāĻŋ True āĻšāĻŋāĻ¸ā§āĻŦā§ āĻŽā§āĻ˛ā§āĻ¯āĻžā§āĻŋāĻ¤ āĻšā§, āĻ¤āĻžāĻšāĻ˛ā§ āĻĢāĻžāĻāĻļāĻ¨āĻāĻŋ ExpressionTrue āĻāĻ° āĻĢāĻ˛āĻžāĻĢāĻ˛ āĻĒā§āĻ°āĻĻāĻžāĻ¨ āĻāĻ°ā§ āĻĨāĻžāĻā§, āĻ āĻ¨ā§āĻ¯āĻĨāĻžā§ āĻāĻāĻŋ ExpressionFalse āĻāĻ° āĻĢāĻ˛āĻžāĻĢāĻ˛ āĻĒā§āĻ°āĻĻāĻžāĻ¨ āĻāĻ°ā§ āĻĨāĻžāĻā§āĨ¤
ExpressionTrue, ExpressionFalse: āĻ¯ā§āĻā§āĻ¨ā§ āĻāĻā§āĻ¸āĻĒā§āĻ°ā§āĻļāĻ¨, āĻ¯āĻžāĻ° āĻāĻāĻāĻŋ āĻ˛āĻāĻŋāĻā§āĻ¯āĻžāĻ˛ āĻŽā§āĻ˛ā§āĻ¯āĻžā§āĻ¨ā§āĻ° āĻāĻĒāĻ° āĻ¨āĻŋāĻ°ā§āĻāĻ° āĻāĻ°ā§ āĻĢāĻžāĻāĻļāĻ¨ āĻĢāĻ˛āĻžāĻĢāĻ˛ āĻšāĻŋāĻ¸ā§āĻŦā§ āĻĒā§āĻ°āĻĻāĻžāĻ¨ āĻāĻ°āĻž āĻšāĻŦā§āĨ¤
IIf evaluates both ExpressionTrue and ExpressionFalse even if it returns only one of them. If one of the expressions results in error, the function returns the error. For example, do not use IIF to bypass a possible division by zero result.
REM Returns the maximum of 3 values
Function Max (A As Double, B As Double, C, As Double) As Double
Max = IIf( A >= B, A, B)
Max = IIf( C >= Max, C, Max)
End Function
REM Bad usage of function IIf
Function Inverse(A As Double) As Double
Inverse = IIf( A = 0, 0, 1/A )
End Function