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...
The ________ bar displays at the bottom of the screen where you type the address of the website you want to visit or a search term
A) tabs B) address C) favorites D) status
Computer Science & Information Technology
Which tag is used to force the browser to display the next text or element on a new line?
a.
c.
d.
Computer Science & Information Technology
Explain NP-complete problems in your own words.
What will be an ideal response?
Computer Science & Information Technology
List the Site Summary categories, some sample report names, and what the reports are used for.
What will be an ideal response?
Computer Science & Information Technology