Question

If C2=20 and D2=10 what is the result of the function = mathcal I F(C2=D2,^ prime prime Ful "Open")?
Open
Unknown
Full
10​

Answer 1

Excel IF functions are used to test conditions.

The result of the IF function is (a) Open

The function is given as: = IF(C2 = D2, "Full","Open")

Where: C2 = 20 and D2= 10

The syntax of an Excel IF conditional statement is: = IF (Condition, value_if_true, value_if_false)

The condition is: IF C2 = D2

The values of C2 and D2 are: 20 and 10, respectively.

This means that, 20 does not equal 10.

So, the value_if_false will be the result of the condition.

In other words, the result of the IF function is (a) Open

Read more about Excel functions at:

https://brainly.com/question/10307135