Microsoft Excel provides logical formulas to enable to select the data depending on the given criteria. For example, select the data; if some condition(s) satisfies.
In this Article, we will go through; IF
, IFERROR
and IFNA
Logical Functions in Microsoft Excel.
IF
function
The syntax of this function is:
=IF(condition, [true-value], [false-value])
IF function takes condition
as an argument and if it satisfies the condition, the value given in true-value
will be displayed; otherwise, the value given in false-value
will be displayed.
Note that, all the arguments to IF
formula are mandatory; but values to true-value
and false-value
are optional. Here are some examples of this function;
Formula | Result | Comments |
=IF(10 > 8, 10, 8) | 10 | |
=IF(“A” > “B”, “A”, “B”) | B | |
=IF(TRUE=FALSE,,) | 0 | Observe, no values passed to last two arguments. |
IFERROR
function
The syntax of this function is:
=IFERROR(value, error-value)
IFERROR function verifies the result of the value
is an error; if it has any error, the value of error-value
argument will be displayed. Otherwise, the result of the value
will be displayed. These arguments can be; values, expressions, formulas or etc,. Here is an example;
=IFERROR(1/0, “Division by zero”)
which displays the error value as the first argument evaluates an error.
IFNA
function
The syntax of this function is:
=IFNA(value, na-value)
Excel will return #N/A errors, usually when a formula can’t find a reference value. Commonly LOOKUP functions produce this Error. Using this function, we are allowed to display an alternate value instead of #N/A Error, when it occurred.
We will discuss more Excel functions in upcoming Articles.
🙂 Sahida
2 thoughts on “Microsoft Excel – Logical Functions – IF, IFERROR and IFNA formulas”