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
=IF(F3<50,"N","Y")
B
=IF(F3>=50,"Y","N")
登录即可查看完整答案
我们收录了全球超50000道真实原题与详细解析,现在登录,立即获得答案。
类似问题
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...
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.
更多留学生实用工具
希望你的学习变得更简单
加入我们，立即解锁 海量真题 与 独家解析，让复习快人一步！