• • • • • • • • • • • • • • • ## What is logical test in excel?

Written by kazamraza
Classified in : Excel Formulas, Logical Functions Tags : none

Logical test means a condition when evaluated by computer whose result/outcome is true or false, there is no third option, for example if a student secures more than 45 marks it is considered as pass otherwise fail.

In Excel a single IF function (IF(logical_test, value_if_true, value_if_false)) evaluate only one logical test at one time, if we have more than one conditions/logical tests, then we use AND function or OR function along with IF Function.

Read more What is logical test in excel?

## TRUE Function

Written by kazamraza
Classified in : Excel Formulas, Logical Functions Tags : none

Returns the logical value TRUE. You can use this function when you want to return the value TRUE based on a condition. For example:

``````
=IF(A1=1,TRUE())
``````

You can also enter the value TRUE directly into cells and formulas without using this function. For example:

``````
=IF(A1=1,TRUE)
``````

If the condition is met, Excel returns TRUE in both examples. If the condition is not met, Excel returns FALSE in both examples.

## IFERROR Function

Written by kazamraza
Classified in : Excel Formulas, Logical Functions Tags : none

You can use the IFERROR function to trap and handle errors in a formula. IFERROR returns a value you specify if a formula evaluates to an error; otherwise, it returns the result of the formula.