What is logical test in excel?

Written by kazamraza no comments
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.

When evaluating one condition, we use simple if function.

IF(logical_test, value_if_true, value_if_false)


When evaluating more than one condition, we use IF Function and AND/OR Function.

IF(AND(logical_test,, logical_test2, logical_test,......), value_if_true, value_if_false)