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
Get step-by-step solutions from verified subject matter experts
