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...   单项选择题

A

=2*C$1

B

=0

C

=0*C$1

D

=1*C$1

登录即可查看完整答案

我们收录了全球超50000道真实原题与详细解析,现在登录,立即获得答案。

类似问题

For this question only, instead of using a VLOOKUP function, you want to complete column E (cells E2:E21) using an IF function (or nested IF). The rules remain the same as in the previous question: ports coded 200-499 are in the Northern Region, and those coded 500-999 are in the Southern Region. Completing column E (cells E2:E21) using an IF function, or nested IF functions, instead of a VLOOKUP function is (choose the best answer below):

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.

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.

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?

更多留学生实用工具

加入我们，立即解锁 海量真题 与 独家解析，让复习快人一步！