If the payment amount due is more than $100 and the number of days late is more than 4, account should say "Review", otherwise cell should be blank.Which IF statements are correct? Select all that are correct.

Question

BlackTom AI · Accepted Answer

We are evaluating which IF statements correctly implement the rule: if the payment amount due is more than $100 AND the number of days late is more than 4, the cell should say "Review", otherwise it should be blank.

Option a: =IF(B2>100,IF(C2>4,"Review",""),"")
- This nested-IF checks B2>100 first, and if true, it then checks C2>4 to decide between "Review" and an empty string. If B2 is not >100, it returns the blank shown as "". This matches the required logic precisely and uses proper string literals. It is a correct implementation.

Option b: =IF(AND(B2>100,C2>4),Review,"")
- The AND() part is fine for combining conditions, but the value_if_true is Review without quotes. In Excel, text literals must be enclosed in quotes. Without quotes, Excel will look for a named range or variable called Review, which will cause a #NAME? error. This makes the formula incorrect.

Option c: =IF(AND(B2>100,C2>4),"Review",Blank)
- Here, the true result is the string "Review" correctly quoted, but the false result is Blank without quotes. In Excel, Blank is not a recognized literal; the function would expect a string (""), a reference, or another value. Therefore this is syntactically invalid and incorrect.

Option d: =IF(AND(B2>100,C2>4),"Review","")
- This option uses AND(B2>100, C2>4) to gate the true outcome, and returns "Review" when true and an empty string when false. The logic and syntax are both correct, and it directly implements the required rule. This is also a correct implementation.

Summary
- Correct: a and d, because both properly implement the conditional of showing "Review" only when B2>100 and C2>4, otherwise returning a blank.
- Incorrect: b, due to missing quotes around the text literal; c, due to an unquoted Blank which is not a valid Excel value.

FNDN Computing for Business 2025 STD O1

If the payment amount due is more than $100 and the number of days late is more than 4, account should say "Review", otherwise cell should be blank.Which IF statements are correct? Select all that are correct.

查看解析

登录即可查看完整答案

类似问题

In this nested IF function example, =IF(C4<1000,0,IF(C4<2000,2,1))*C$1 if the value in C4 is 1200, the result is...

Review the following Excel formula and choose the correct statement: =IF( A1 > 10, "High", IF( A1 > 5, "Medium", "Low") ) Spaces are added to the formula above to make the text easier to read and will not affect the result.

Emma wants to check if her total sales in cell D4 meet or exceed $5,000. Which function should she enter into cell E4 to return "Target Achieved" if the sales meet the target, and "Below Target" if they do not?

A university is evaluating student grades using an Excel spreadsheet. In column G it would like to indicate "Y" for those whose final grade is 50 and above, and "N" otherwise. What is the correct formula it should enter in cell G3? Choose all correct answers.

A university is evaluating student grades using an Excel spreadsheet. In column G it would like to indicate "Y" for those whose final grade is 50 and above, and "N" otherwise. What is the correct formula it should enter in cell G3? Choose all correct answers.

更多留学生实用工具

考试浏览器助手

风格化写作助手

论文查重助手

文献引用助手

课堂转译助手

课堂笔记助手

Quiz搜索助手

学校历年真题

智能刷题助手

智能匹配练习

希望你的学习变得更简单