The Excel IFNA function is a simple way to trap and handle #N/A errors specifically without catching other errors. The IFNA function returns a custom result when a formula generates the #N/A error, and a normal result when no error […]
Read more →
We can use the NOT function to reverse a logical value. The NOT function returns the opposite of a given logical or Boolean value. For example : If supplied with the value TRUE, the Not function returns FALSE; If supplied […]
Read more →
The XOR function performs what is called “exclusive OR”. With two logical statements, XOR returns TRUE if either statement is TRUE, but returns FALSE if both statements are TRUE. If neither is TRUE, XOR also returns FALSE. Syntax The syntax […]
Read more →
The Excel TRUE function returns the Boolean value TRUE. The TRUE function is classified as a “compatibility function”, needed only for compatibility with other spreadsheet applications. There is no need to use TRUE() if you are creating a spreadsheet in […]
Read more →
The Excel FALSE function returns the Boolean value FALSE. The FALSE function is classified as a “compatibility function”, needed only for compatibility with other spreadsheet applications. There is no need to use FALSE() if you are creating a spreadsheet in […]
Read more →
The IF function runs a logical test and returns one value for a TRUE result, and another for a FALSE result. For example, to “pass” scores above 60: =IF(A1>60,”Pass”,”Fail”). More than one condition can be tested by nesting IF functions. […]
Read more →
The IFS function can run multiple tests and return a value corresponding to the first TRUE result. Use the IFS function to evaluate multiple conditions without multiple nested IF statements. IFS allows shorter, easier to read formulas. Syntax The syntax […]
Read more →
The Excel SWITCH function compares one value against a list of values, and returns a result corresponding to the first match found. When no match is found, SWITCH can return an optional default value. Syntax The syntax for the SWITCH […]
Read more →
The Excel IFERROR function returns a custom result when a formula generates an error, and a standard result when no error is detected. IFERROR is an elegant way to trap and manage errors without using more complicated nested IF statements. […]
Read more →
The AND function is a logical function used to require more than one condition at the same time. AND returns either TRUE or FALSE. To test if a number in A1 is greater than zero and less than 10, use […]
Read more →