Multiple Choice
Which of the following is the correct syntax when using the AND function within the IF function?
A) =IF((B3<5 AND C1>7) ,"Pass","Fail")
B) =IF(AND(B3<5,C1>7) ,"Pass","Fail")
C) =IF(AND(B3<5 OR C1>7) ,"Pass","Fail")
D) =AND(IF(B3<5,C1>7) ,"Pass","Fail")
Correct Answer:
Verified
Correct Answer:
Verified
Related Questions
Q56: Excel color codes parentheses for each function
Q57: The _ function is a useful tool
Q58: The INDEX function works with the MATCH
Q59: _ functions enable evaluation and choices to
Q60: The third argument of the AVERAGEIF function
Q62: VLOOKUP and HLOOKUP are two functions used
Q63: Match the following terms to their description.
Q64: The _ function is the most common
Q65: The _ function is a database function
Q66: Match the following terms to their description.