India Exam Junction

20. What is the correct syntax of IF() Function ?

  1. = IF (logical_test, TRUE([value_if_true]), FALSE([value_if_false]))

  2. = IF (logical_test, [value_if_true], [value_if_false])

  3. = IF (logical_test, {[value_if_true]}, {[value_if_false]})

  4. = IF (logical_test : [value_if_true], [value_if_false])

Correct Answer :

= IF (logical_test, [value_if_true], [value_if_false])

Solution

The IF() function in Excel evaluates a condition (logical_test) and returns one value if the condition is TRUE and another if it is FALSE.

=IF(logical_test, [value_if_true], [value_if_false])

  • logical_test: The condition to evaluate (e.g., A1>10).
  • value_if_true: The result if the condition is true.
  • value_if_false: The result if the condition is false.

Example:

=IF(A1>10, "Pass", "Fail")

This checks if the value in cell A1 is greater than 10. If true, it returns "Pass"; otherwise, "Fail."

Join The Discussion
Comments (0)