Nathan wants a formula to return "Yes" if the value in cell A1 is less than the value in cell B1, and to return "No" otherwise. Which of the following functions should he use?
A) IFERROR
B) VLOOKUP
C) IF
D) RAND

Question

Quizplus · Accepted Answer

Nathan should use the IF function. The syntax for the IF function is IF(logical_test, value_if_true, value_if_false). In this case, the logical test would be A1<B1, and the value_if_true would be "Yes", and the value_if_false would be "No". Therefore, the formula would be =IF(A1<B1, "Yes", "No").

Nathan Wants a Formula to Return "Yes" If the Value