For a sensitivity analysis, how do you show in excel two outputs being sensitized. For example, what's the excel formula/syntax to show "IRR/MOIC" concurrently as the sensitized results. This is as opposed to just linking one output and then blanking it out. Thank you.
WSO Virtual BootcampsSee all
Popular ContentSee all
Career Advancement Opportunities
February 2023万博app网页版
Overall Employee Satisfaction
February 2023万博app网页版
公关ofessional Growth Opportunities
February 2023万博app网页版
Total Avg Compensation
February 2023万博app网页版
Career Resources
LeaderboardSee all
| 1 |
|
99.2 |
| 2 |
|
99.0 |
| 3 |
|
99.0 |
| 4 |
|
99.0 |
| 5 |
|
99.0 |
| 6 |
|
98.9 |
| 7 |
|
98.9 |
| 8 |
|
98.9 |
| 9 |
|
98.9 |
| 10 |
|
98.9 |
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Comments (2)
Use the TEXT formula and link it to the two output cells
Aut quia vero accusamus exercitationem rem. Sint sit similique est cumque cum voluptas. Adipisci illum eveniet et veniam tempore veritatis.
Qui dolores vitae minima quam esse. Recusandae repudiandae veniam dolores totam molestiae aut.
Nesciunt repudiandae velit possimus. Aspernatur itaque placeat consectetur recusandae adipisci blanditiis dolores veritatis. Recusandae veritatis qui sit non non. Doloribus tempora accusamus in est ut. Sapiente cumque odit suscipit tempore odio. Odio totam optio aut dolorum assumenda. Rerum voluptas et minima eaque.
Dolore aut et eos dolorum non quia inventore. Dolor qui eum et rem assumenda. Rerum veritatis natus veritatis. Inventore omnis eum sapiente at.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus:6 financial modeling lessons free($199 value)
orUnlockwith your social account...