Home » MCQs » Microsoft Excel MCQs

What is the correct syntax of IF() function?

19. What is the correct syntax of IF() function?

1. =IF (logical_test, {[value_if_true]}, {[value_if_false]})
2. =IF (logical_test, TRUE([value_if_true]), FALSE([value_if_false]))
3. =IF (logical_test: [value_if_true], [value_if_false])
4. =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])