Category: Logical

IFNA function

This function will return a specified value if your given expression results in an #N/A error. Only the #N/A! error will result in the alternate value. Syntax IFNA(Expression, Value if #N/A!) Expression (required) – This...

Read More

TRUE function

This function will return the TRUE value. This is the same as just entering the value TRUE. Syntax TRUE() There are no arguments for this function. Example In this example we return the TRUE value....

Read More

FALSE function

This function will return the FALSE value. This is the same as just entering the value FALSE Syntax FALSE() There are no arguments for this function. Example In this example we return the FALSE value....

Read More

XOR function

This function will return TRUE if exactly one of the arguments are TRUE and FALSE otherwise.   Syntax   XOR(Expression1, Expression2, Expression3, … ) Expression1 (required) – This is an expression that can...

Read More

OR function

This function will return TRUE if one or more of the arguments are TRUE and FALSE if all the are FALSE.   Syntax   OR(Expression1, Expression2, Expression3, … ) Expression1 (required) – This is an...

Read More

AND function

This function will return TRUE if all arguments are TRUE and FALSE otherwise.   Syntax   AND(Expression1, Expression2, Expression3, … ) Expression1 (required) – This is an expression that can evaluate to...

Read More
Loading

Follow Us

Free Book

Recent Tweets

Categories

Pin It on Pinterest