Quiz 7- IF Functions- AIS
¡Supera tus tareas y exámenes ahora con Quizwiz!
What is the syntax of IF() function?
A- =IF(logical test, value if true, value if false)
How do you put an IF() function into an Excel worksheet?
D- You may use either a or b, above.
What is the result of the following formula? =IF(C2>500,"Good","Not Good") when cell C2 contains the value 500?
NO- D- Formula is invalid NO- C- No results will appear
What function offers you the possibility to view different results depending on the entered condition?
NO- D-TrueFalse() A- If()
What logical tests are allowed within an IF() function? (select all that are correct)
YES = Equal YES <> Not equal & Concatenate YES < less than =< equal to or less than YES<= less than or equal to YES > greater than YES >= greater than or equal to + Adds to ≠ not
