Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions