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.
A) =IF(G7=9)(G7=7)=OR(G7=4)
B) =IF(G7=7)=THEN(C3=9)=OR(C3=4)
C) =IF(C3=9)(C3=7)=OR(C3=4)
D) =IF(C3=9,7,4)

Question

Quizplus · Accepted Answer

The IF function in cell G7 would evaluate the condition of whether the value in cell C3 is equal to 9. If it is, then the number 7 will be assigned to G7; if it isn't, then the number 4 will be assigned to G7. The IF function syntax requires three arguments: the condition to be tested, the value if the condition is true, and the value if the condition is false. The correct syntax for this specific scenario is =IF(C3=9,7,4).

If Cell G7 Contains the Function , It States That