Question: A function is entered into an Excel worksheet to evaluate the values in cells C 4 and D 4 . If the value in C

A function is entered into an Excel worksheet to evaluate the values in cells C4 and D4. If the value in C4 is greater than 10 the output of the function should be the word OK. If the output in cell D4 is greater than or equal to 2, the output should also be the word OK. Otherwise the output should read LOW. Which of the following IF functions will provide an accurate output given the requirements provided?
Group of answer choices
=IF(C4>10 or D4>2 or D4=2,OK,LOW)
=IF(OR(C4>10,D4>2,=2),OK,LOW)
=IF(OR(D4>=2,C4>10),OK,LOW)
=IF(AND(C4>10, D4>=2),OK,LOW)
=IF(C4>10 and D4>2 and D4=2,OK,LOW)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!