#1030103
Give 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.
Варианты ответа:
  • =IF(B7=12,(AND(B10=10, "")(YES)),7)
  • =IF(B10=10,(OR(B7=12,"")"YES")7)
  • =IF(B7=12,(IF(B10=10,"YES", "")),7)
  • =IF(B7=12,(AND(B10=10,"YES","")(B10="NO"),7)
Тематика: Математические и инструментальные методы поддержки принятия решений Системный анализ и принятие решений Учет и анализ
Курсы в категории: Математика и статистика
📚 Похожие вопросы по этой дисциплине
If cell G7 contains the function …, it states that if the value in cell C3 is 9, the number 7 will be assigned to cell G7; if the value in cell C3 is not 9, th A manager at Gampco Inc. wishes to know the company's revenue and profit in its previous quarter. Which of the following business The function … returns a value or reference of the cell at the intersection of a particular row and Which of the following Lookup functions returns the relative position of an item in an array that equals a specified In a MATCH function, if the match_type =