Question

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?

Answer 1

IF function

Step-by-step explanation:

The options to the question are missing; however, I'll assume the question related to Microsoft Office Excel.

To do the task in the question, Nathan can only make use of the IF function.

This is so, because the question relates to conditional statement.

The full if statement is:.

=IF(A1 < B1, "YES","NO")