Tabel persamaan semua no tr1/20/2023 ![]() ![]() If you want to analyze more than two variables, you should instead use scenarios. ![]() Because you focus on only one or two variables, results are easy to read and share in tabular form.Ī data table cannot accommodate more than two variables. Using data tables makes it easy to examine a range of possibilities at a glance. ![]() Unlike scenarios, data tables show you all the outcomes in one table on one worksheet. Like scenarios, data tables help you explore a set of possible outcomes. Goal-seek is distinctly different, it uses a single result and calculates possible input values that would produce that result. Scenarios and data tables use sets of input values to calculates possible results. There are three types of what-if analysis tools in Excel: scenarios, data tables, and goal-seek. For more information, see Excel What-If Data Tables: Faster calculation with VBA. Note: You can perform faster calculations with data tables and Visual Basic for Applications (VBA). ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |