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")
Answer: B
Computer Science & Information Technology
You might also like to view...
Which of the following contains information about object properties, relationships, and permissions in a database?
A) Database documentation B) Relationship report C) Entity relationship diagram D) Entity relationship documentation
Computer Science & Information Technology
_________ returns the last character in a StringBuilder variable named strBuf?
a. strBuf.charAt(strBuf.length() - 1) b. strBuf.charAt(strBuf.capacity() - 1) c. StringBuilder.charAt(strBuf.length() - 1) d. StringBuilder.charAt(strBuf.capacity() - 1)
Computer Science & Information Technology