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) =IFG7=9)G7=7)=ORG7=4)
B) =IFG7=7)=THENC3=9)=ORC3=4)
C) =IFC3=9)C3=7)=ORC3=4)
D) =IFC3=9,7,4)

Question

Quizplus · Accepted Answer

The correct syntax for an IF function in Excel is =IF(logical_test, value_if_true, value_if_false). Option D correctly applies this syntax to check if C3 is 9, then return 7, otherwise return 4.

If Cell G7 Contains the Function , It States That