Which of the following is not a valid =IF statement?
A)=IF(A519,"Greater","Not Greater")
B)=IF(A519,b7,b9)
C)=IF(A519,1,9)
D)=IF(A519,Greater,Not Greater)

Question

Which of the following is not a valid =IF statement?
A)=IF(A5>19,"Greater","Not Greater")
B)=IF(A5>19,b7,b9)
C)=IF(A5>19,1,9)
D)=IF(A5>19,Greater,Not Greater)

Quizplus · Accepted Answer

Option D is not a valid IF statement because "Greater" and "Not Greater" are not enclosed in quotes, making them non-existent cell or range references or undefined named ranges. All text or string values used in IF statements should be enclosed in quotes.

Which of the Following Is Not a Valid =IF Statement