What is the correct syntax of IF() function in Excel?
=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])
Correct answer is D
The correct syntax of IF() function is:
=IF (logical_test, [value_if_true], [value_if_false])