Question: 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!