#1030104
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, the number 4 will be assigned to cell G7.
Варианты ответа:
  • =IF(G7=9)(G7=7)=OR(G7=4)
  • =IF(G7=7)=THEN(C3=9)=OR(C3=4)
  • =IF(C3=9)(C3=7)=OR(C3=4)
  • =IF(C3=9,7,4)
Тематика: Математические и инструментальные методы поддержки принятия решений Системный анализ и принятие решений Учет и анализ
Курсы в категории: Математика и статистика
📚 Похожие вопросы по этой дисциплине
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 = For which of the following MATCH functions must the values in the lookup_array be ordered