Tag: How to do a what if analysis in excel

Ever find yourself wondering if Excel could help you answer the question: "What values would I need to get a known result?" The What-if Analysis features, available in Excel 2010 and up, give you the tools to do just that. Unlike functions and formulas that take given values and return…

If you think of Excel as just a database for storing dead data, you will be pleasantly surprised to learn about Excel's What-if analysis tools. Excel offers several features that allow a user to make predictions, or evaluate outcomes based upon variable inputs. In this article, we are going to…