ive the logical function for the following: If cell B7 equals 12, check contents

Question

ive the logical function for the following: If cell B7 equals 12, check contents of cell B10. If cell B10 is 10, then the value of the function in the string is YES; if not, it is a blank space. If cell B7 does not equal 12, then the value of the function is 7. A)-IF(B7-12,(AND(Bl 0-10, "")(YES)),7) B) -IF B10-10, (OR(B7-12,"")"YES")7) C) -IF(B7-12,(IF(B10-10, "YES", w),7) D) -IF(B7-12,(AND(B10-10, "YES","n(B10-"NO"),7) Answer: Use the data given below to answer the following next 2 question(s) Following is an extract from the Employee Payroll Database of HFR Informatics Inc. Employee Ethnic Group Gender Rank/Grade Pay Scale Asian American Female White American Maria Peter Male George Hispanic AmericanMale Smith Black American Female Johnson Alaska Native Male Thompson Asian American Male Martinez Alaska Native Lewis Lee Male White American Female Black American Male Taylor Asian American Female Carter Asian American Male

Explanation / Answer

Correct Choice : C) =IF(B7=12,(IF(B10=10,"YES","")),7)

Explanation : Note that "AND" function nested inside the outer IF expression doesn't produce the result that we intend to obtain. So option A and D are ruled out. Similarly, "OR" function doesn't achieve the desired result. So the correct choice is C.

Dear student,If you find this answer helpful, do provide your valuable feedback through voting and commenting.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.