top of page

What if Analysis in MS Excel

What-If Analysis is built in function in MS Excel. It is the process of changing the values in cells to see how those changes will affect the outcome of formulas on the worksheet.


एमएस एक्सेल में what-if analysis फ़ंक्शन अंतर्निहित है। यह cells में मानों को बदलने की प्रक्रिया है ताकि यह देखा जा सके कि वे परिवर्तन कार्यपत्रक पर सूत्रों के results को कैसे प्रभावित करेंगे।

There are three types of What-If Analysis tools

1. Scenarios

2. Goal Seek

3. Data Tables

Scenarios: allows us to create and save different group of value, scenarios and switch between them.

Goal Seek: It finds the right input when we know the result we want.

Data tables: It allows us to see the results of many different possible inputs at same time.

In other words we can say that Scenarios and Data tables take sets of input values and determine possible results.

What if Analysis Video By Rajesh Sir:



182 views0 comments

Recent Posts

See All

Comments


bottom of page