How do You Use “What if” Questions with Excel Formulas?
How do You Use “What if” Questions with Excel Formulas?”What if” questions involve changing the data used in Microsoft Excel formulas to give different answers.Answer: Excel formulas can easily be used to answer “What if” – type questions such as: • “What if I spent this amount for a new car versus that amount, how much will the taxes be?” • “What if I worked this number of hours versus that number in a week, how much would I earn?” To answer questions like these easily with Excel, your formulas needs to be created using cell references rather than entering your data. Cell references identify the location of your data in the spreadsheet, such as B4 or B5. Example – Formula using cell references = B4*B5 In this example the formula multiplies the contents of cell B4 times the contents of cell B5. Referring to the image to the right, our example is arranged in the
