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) AND
B) IF
C) NOT
D) ROUND

Question

Quizplus · Accepted Answer

Nathan needs to use an IF function to compare the values in A1 and B1. The IF function will return "Yes" if the condition (A1<B1) is true and "No" otherwise.

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