Home »
MCQs »
Microsoft Excel MCQs
What is the correct syntax of IF() function?
19. What is the correct syntax of IF() function?
- =IF (logical_test, {[value_if_true]}, {[value_if_false]})
- =IF (logical_test, TRUE([value_if_true]), FALSE([value_if_false]))
- =IF (logical_test: [value_if_true], [value_if_false])
- =IF (logical_test, [value_if_true], [value_if_false])
Answer: D) =IF (logical_test, [value_if_true], [value_if_false])
Explanation:
The correct syntax of IF() function is:
=IF (logical_test, [value_if_true], [value_if_false])