What is logical test in excel?
Written by kazamraza no comments
Classified in : Excel Formulas, Logical Functions
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)