P2: Making Decisions And Looking Up. Values

Submitted By wjyqq2011
Words: 2436
Pages: 10
Open Document
P1: OTA/XYZ c05 P2: ABC

JWBT166-Sengupta

August 4, 2009

10:20

Malloy

CHAPTER

5

Making Decisions and Looking Up
Values

ne reason Excel is so useful is that it can do an enormous number of complex calculations accurately and fast. But if it could do only straightforward calculations, then it would not be half as useful as it is. A significant part of its usefulness or power comes from the fact that in Excel you can write formulas to make various kinds of decisions equally quickly and accurately.
What do we mean by making decisions? Making decisions means choosing which path or action to take out of several possibilities depending on the results of one or more conditions or tests. If you think about it you will realize that this is very similar to what we mean by making decisions and how we make decisions in real life as well, even though we generally do not explicitly think about what conditions or tests we are considering to decide what action we would take.
In financial models, you will often need to use Excel’s decision-making abilities. Although most Excel users know how to set up simple decision making in Excel, they cannot create complex decision structures, and they think that the problem is that they do not know Excel well enough or do not know all the necessary features. But most of the time the real problem is that to set up a decision-making structure you have to first lay out in clear and precise steps exactly how a decision is to be made. Since we do not make decisions in such clear and precise steps, it takes some conscious practice to learn and document the steps of a decision. Once you have thought through and documented exactly how a decision is to be made, translating it into Excel formulas is not that difficult. In this chapter, I will introduce Excel’s decision-making tools. But more important, by using several examples I will show you how can break down a decision into steps and then translate it into Excel’s language. Learning to create decision structures is very important for financial modeling. You should devote the necessary time and effort to learn it well and then practice writing decision making formulas at every opportunity you get.

O

77

P1: OTA/XYZ c05 P2: ABC

JWBT166-Sengupta

August 4, 2009

78

10:20

Malloy

EXCEL FOR FINANCIAL ANALYSIS AND MODELING

I will also cover two other groups of Excel’s features that act very much like decision making. The first is looking up the value for something from a list or table depending on certain specified conditions or tests. This is a very powerful use of Excel. The second is formatting one or more cells differently depending on their content. This capability, called conditional formatting, is very useful to make your data or model outputs more clear and attractive. The conditional formatting feature has been significantly enhanced in Excel 2007. You will be able to use conditional formatting with its full power only if you are using Excel 2007.

Logical Values
Excel includes two logical values, TRUE and FALSE, which you can use in formulas or which can be the results of certain computations. (How and why you use them will become clear a little later.) For Excel to recognize these as logical values and not confuse them with text, you have to write them in your formulas in all capitals, as shown, and without the quotation marks normally used for texts.
Excel also provides two functions, TRUE() and FALSE()—they do not take any arguments—which return the values TRUE and FALSE. These functions are provided only for compatibility with other spreadsheet programs. You will not need to use them because entering TRUE or FALSE anywhere is the same as entering the equivalent function.

Making Decisions
Excel offers several logical functions that you can use to give your formulas simple to fairly complex decision-making abilities. The IF function is the workhorse of
this
Show More

Related Documents: P2: Making Decisions And Looking Up. Values

Nestlé Alimentana S.A. - Infant Formula Essay

boom and the appearance of third world countries (Less Developed Countries – LDC’s) mothers in general were unable to feed their children with all the needed nutrients that a normal child must have, this is basically why the infant formula was created. The infant formula was created by companies in the pharmaceutical industry and Nestlé. Nestlé easily got a high market share in the industry. The general health problems in the aftermath cause a great impact on babies. The number of sick babies increased…

Words 1642 - Pages 7

Compare and Contrast Breast Feeding vs Bottle Feeding Essay examples

A plethora of questions and concerns arise upon confirmation of pregnancy; however, the decision on whether to breastfeed or formula feed an infant seems to be one of the more crucial decisions. Moms new to nursing a baby need all the information that they can get in order to help choose which method of feeding is more suitable, because every mother wants what is best for their child. Unlike formula feeding, the benefits of breastfeeding are substantial for both mother and baby. Moreover, choosing…

Words 981 - Pages 4

Essay on Unit 37 P1

in an ethical way involves making the right choice between the right and wrong one. To be ethical it requires organizations to act in ways that stakeholders consider to be both fair and honest. People who make ethical business decisions will consider what and who their decisions may affect or harm and if their decisions will be considered fair by people who are affected.1 2 There are many ethical issues that all businesses will have to consider when making decisions. For example, it is ethical…

Words 1776 - Pages 8

Breastfeeding Vs Bottle Feeding

The task of deciding whether to breastfeed or formula feed a newborn is not an easy one for new mothers. Many health experts recommend breastmilk over any other supplementation; however, there are several aspects for the new mother to consider when making their decision. While greater factors like medical conditions may limit the ability to choose, some smaller factors like comfortability will also have an impact. Weighing the benefits and emotional affects it will have on the new mom and time-consumption…

Words 1022 - Pages 5

Bernie Ecclestone's Formula for Formula One Essay

VIRÁG SZOMORA EXAM NR.: 319595 2013 JANUARY MANAGEMENT OF TECHNOLOGY ASSIGNMENT #3 BERNIE ECCLESTONE’S FORMULA FOR FORMULA ONE UNIVERSITY OF SOUTHERN DENMARK 2013 JANUARY 1 VIRÁG SZOMORA EXAM NR.: 319595 2013 JANUARY „They say Formula One is a market which it can’t be, obviously. Our market is independent, it’s a sport.” (Bernie Ecclestone) Formula One is one of the biggest businesses in the world since the 1980s. The motor racing sport itself is more than a century old…

Words 2947 - Pages 12

Essay on Cmst 230 Journal

Improving Decisions in an Organization The main topic of this article is how an organizational leader can make better decisions for his company and ones his subordinates will be more willing to follow. The article gives guidelines for decision making based on the problem at hand. The author provides the dimensions of effective decisions, the first dimension is the objective or impersonal quality of the decision. The second is the acceptance or the way the persons who must execute the decision feel…

Words 825 - Pages 4

Curtin 201 Management Accounting Essay

Content 1. The purpose of a cost formula and its components 2 2. The cost formulas derived and their respective evaluation 2 2.1. The cost formulas 2 2.2. The evaluation of cost formulas 3 3. Result and explanation: total costs predicted as requested 6 3.1. Scenario one: labor hours increase to 8500 6 3.2. Scenario two: machine hours increase to 2300 6 4. Product cost of the Road, Trek and BMX bicycles 8 5. Activity-based costing (ABC): concept, benefits and limitations 9 6. Justification of Island…

Words 1937 - Pages 8

Breast Feeding Research

Unit 11 Task 1 Breast feeding is what most women in England choose to do as it is the healthiest way to feed your baby and most hospitals will recommend that you breastfeed your child for around the first 6 months. The decision on breast vs. bottle feeding is a very personal one and you should not be pressured into doing either one. You will need to consider your lifestyle, medical history and your personal comfort level. There are many advantages to breast feeding; breast feeding is the only natural…

Words 2403 - Pages 10

Btec Business Level 3 Unit 3 P1

with worksheets. I will also be designing spreadsheets to help the sales employees gather customer orders. My spreadsheet that I am making will contain multiple worksheets to hold items, prices and customer quotations. I will also include surveys sheets and quotations. I will make sure that the spreadsheet is formatted appropriately and that I use the functions and formulas within Excel to solve the complex problems within the MOD business. I will assist the sales people when quoting the sales customers…

Words 1761 - Pages 8

Qlt1 Task 1

selected does not matter because it was not specified in this problem. Therefore, I came to the conclusion that there are 847,660,528 ways that the participants can be selected. The easiest way that I came to this answer was that I used the combination formula, because like I said earlier, the order does not matter for the selection process. Task 1 Part 2 Question: There are 15 research doctors participating in the study and the research board needs to be established with the offices of director, assistant…

Words 818 - Pages 4