Question

Which of the following is a TRUE statement regarding the IF function

Select one:

a. The IF function can only evaluate values.

b. Formula: =IF (B10> 100, Bananas, Oranges) will return Oranges if B10 has a value of 55

c. Only one condition can be tested by nesting IF functions.

d. It is not good practice to have constants in an IF statement.

Answer 1

Correct answer:

Option A: the IF functions can only evaluate values.

Explanation:

In excell , If statement is used for evaluation between two values, by putting a condition, of the condition is met, it returns true and if the condition is not satisfied it returns false,

Proper syntax for If statement :

=If(B10>100,"Bananas","Oranges") , in this statement if B10 has a value higher than 100 , if statement will return trus, and The output will be Bananas, nad vice versa.

Multiple conditions can be tested by using nesting if functions

If statement accept constant as input valus, and it is advisable to enter constants .

End of answer

Please give a thumbs up, it will be highly appreciated.

Thanks