In Microsoft Excel,a logical function that returns one value if the condition is true and another if the condition is false,is ________.
A)OR(condition 1,condition 2 ...)
B)IF(condition,value if true,value if false)
C)VLOOKUP(value,table range,column number)
D)AND(condition 1,condition 2…)

Question

Quizplus · Accepted Answer

The IF function returns one value if the condition is true and another if the condition is false. The other options do not provide the same functionality as the IF function.

In Microsoft Excel,a Logical Function That Returns One Value If