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

Question

Bas_tet [7]

3 years ago

6

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.

Computers and Technology

1 answer:

sladkih [1.3K] · Answer 1 · 2022-11-15T09:29:59+03:00

sladkih [1.3K]3 years ago

6 0

Answer:

=IF(C3=9,7,4)

Explanation:

If cell G7 contains the function =IF(C3=9,7,4), 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.