Google News
logo
Microsoft Excel - Quiz(MCQ)
What is the correct syntax of IF() function?
A)
=IF (logical_test, [value_if_true], [value_if_false])
B)
=IF (logical_test: [value_if_true], [value_if_false])
C)
=IF (logical_test, {[value_if_true]}, {[value_if_false]})
D)
=IF (logical_test, TRUE([value_if_true]), FALSE([value_if_false]))

Correct Answer : Option (A) :   =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])

Advertisement