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

Question

ValentinkaMS [17]

3 years ago

8

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

Advanced Placement (AP)

1 answer:

Mnenie [13.5K] · Answer 1 · 2022-03-16T04:46:41+03:00

Answer:

If function

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")