You work as an Office Assistant for Tech Perfect Inc. You are creating a report in a workbook in Excel
2010. Before creating a final report, you are required to test some logical conditions. You enter test
data in a worksheet in the report. The fragment of the sheet is shown below:
You are testing logical conditions to use them in your report later. Which of the following conditional
formulas will return “True”?
A.
=OR(E3>E4, E3<E5)
B.
=AND(E3<E4, E3>E5)
C.
=AND(E3>E4, E3<E5)
D.
=NOT(E3+E4=34)
Explanation:
By using the AND, OR, NOT functions and other mathematical operators, you can create a
conditional formula that results in a logical value. In the current scenario, the following formula will
return “True” value:
=OR(E3>E4, E3
The OR() function in Excel evaluates logical values and returns the value “True” if any argument is
true. The function returns “False” only when all the arguments are false.
Syntax
OR(LogicalCondition1,LogicalCondition2,..)
Here, LogicalCondition1, LogicalCondition2 are test conditions that can be either TRUE or FALSE.
There can be 1 to 255 logical conditions that can be provided as arguments with the OR() function.
Example
The OR() function can also be used to evaluate values in arrays.
Answer C and B are incorrect. The given formula will return “False” as at least one of the arguments
is false. The AND()
function in Excel evaluates logical values and returns the value “True” if all arguments are true. The
function returns “False” if one or all arguments are false.
Syntax
AND(LogicalCondition1,LogicalCondition2,..)
Here, LogicalCondition1, LogicalCondition2 are test conditions that can be either TRUE or FALSE.
There can be 1 to 255 logical conditions that can be provided as arguments with the AND() function.
Example
The AND() function can also be used to evaluate values in arrays.
Answer D is incorrect. The given formula will return “False” as the given argument is true. The NOT()
function in Excel reverses the value of its argument.
Syntax
AND(LogicalCondition)
Here, Logical is a value or expression that can either be TRUE or FALSE. If logical is FALSE, NOT()
returns TRUE; if logical is TRUE, NOT() returns FALSE.
Example
