The syntax of the IF function is IF(logical_ test), value_ if_ false, value_ if

Question

The syntax of the IF function is IF(logical_ test), value_ if_ false, value_ if true). You can nest IF functions as deep as you want, but after you get beyond a nest of three IF functions, the logic becomes difficult to follow. Decision support systems (DSS) are computer programs use to help managers solve complex business problems. A DSS program is actually a model representing a quantitative business problem The Excel spreadsheet program is not useful for a business's DSS needs. The Excel tool called Solver can be used to compute answers to optimization problems.

Explanation / Answer

5. false

value_if_true comes first an then value_if_false

6. false

you can nest upto 7 IFs

7. true.

8. true

9. false

10. true

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---