P L U G - I NT4Decision Making Using ExcelLEARNING OUTCOMES1. Describe the use of the IF

ầu hết các công cụ phân tích quyết định trên thị trường tập trung vào một kỹ thuật phân tích cụ thể, như mô phỏng hoặc cây quyết định. Họ có thể được thay đổi để một ngành công nghiệp cần cụ thể, chẳng hạn như mô hình bảo hiểm. Hơn nữa, | PLUG-IN T4 Decision Making Using Excel LEARNING OUTCOMES Describe the use of the IF function. 1. 2. Compare the functions of Goal Seek and Solver. 3. List the advantages of using the Scenario Manager. Introduction Most of the decision-analysis tools on the market focus on one specific analytical technique like simulation or decision trees. They may be tailored to a specific industry need such as insurance claims modeling. Furthermore the cost of these tools can run into the tens of thousands even millions of dollars such as SAS and Cognos. One integrated set of tools that combines the best analytical methods can be applied to different problems and is reasonably priced is Microsoft Excel. The measure of any business intelligence solution is its ability to derive knowledge from data as discussed in the core units of this book. This plug-in will examine a few of the advanced business analysis tools that have the capability to identify patterns trends and rules and create what-if analyses. There are four areas in this plug-in 1. The IF function is used to conduct conditional tests on values and formulas. 2. The Goal Seek function is used to find an unknown value that produces a desired result. 3. The Solver function is used to calculate an optimum solution based on several variables and constraints. 4. The Scenario Manager function is used to create and evaluate a collection of what-if scenarios containing multiple input values. Creating Formulas Using the IF Function The IF logical function will return one value if a condition is TRUE and another value if the condition is FALSE. Use the IF function when you want to compare two items in your workbook. The IF function looks like this IF logical_test value_if_true value_if_false T4-2 Plug-In T4 Decision Making Using Excel Logical_test is any value or expression that can be evaluated to TRUE or FALSE. For example A10 100 is a logical expression if the value in cell A10 is equal to 100 the expression evaluates to TRUE. .