If A7=21, which of the following =IF statements would produce the result of "Much Greater"?
A) =IF(A7<50,"Greater",IF(A7>20,"Much Greater","Not Greater than 20"))
B) =IF(A7<14,"Greater",IF(A7>20,"Much Greater","Not Greater than 20"))
C) =IF(A7<14,"Greater",IF(A7>20,"Much Greater","Not Greater than 20")
D) =IF(A7>14,"Greater",IF(A7>20,"Much Greater","Not Greater than 20"))
B
Computer Science & Information Technology
You might also like to view...
A group of Excel functions that look up a value in a defined range of cells located in another part of the workbook to find a corresponding value is referred to as:
A. logical functions B. lookup functions C. tabs
Computer Science & Information Technology
When you specify only the filename, the browser assumes the file is in the same folder as the document containing the hypertext link.
Answer the following statement true (T) or false (F)
Computer Science & Information Technology