How to Use TRUE Function
The TRUE function returns the logical value TRUE. Formula: = TRUE() Cautions: Excel interprets it as the logical value TRUE when you type word "TRUE" directly into the cell …
Category: Excel Function
How to Use OR Function
The OR function returns TRUE when at least one condition evaluates to TRUE and returns FALSE if all of its arguments evaluate to FALSE. Formula: = OR(logical1, , …) …
How to Use NOT Function
The NOT function reverses the value of its argument. When the argument is true, the NOT function returns false; when argument is false, the NOT function returns true. Formula: …
How to Use IFNA Function
The IFNA function returns the value you specified when a formula evaluates to the #N/A error, otherwise, the function returns the results of the formula. Formula: = IFNA(value, value_if_na) …
How to Use IFERROR Function
The IFERROR function returns the value you specified when a formula evaluates to an error, otherwise, the function returns the results of the formula. Formula: = IFERROR(value, value_if_error) Explanation: …
How to Use IF Function
IF function is one of the most popular Excel functions. The function returns one value when a condition is true and returns another value when it's false. Formula: = …