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:

In this case, the question asks to compare values in two cells and display an appropriate output based on the comparison made on the contents of both cells...

This can only be done in Excel using the if function.

Th form is as follows:

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