Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Excel 1) If cell A2 contains a value that is less than 75, and SEND will be displayed when the logical test is FALSE, which
Excel
1) If cell A2 contains a value that is less than 75, and "SEND" will be displayed when the logical test is FALSE, which of the following contains the correct IF function syntax?
a) | =IF(A2<75, "DON'T SEND", "SEND") | |||
b) | =IF(A2<75, "SEND", "DON'T SEND") | |||
c) | =IF(A2<>75, "DON'T SEND", "SEND") | |||
d) | =IF(A2<>75, "SEND", "DON'T SEND") | |||
2)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) | =AND(IF(B3<5,C1>7),"Pass","Fail") | |||
c) | =IF(AND(B3<5 or c1>7),"Pass","Fail") | |||
d) | =IF(AND(B3<5,C1>7),"Pass","Fail") | |||
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started