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.
| +85 | Drunk VP. How to manage? | 28 | 9h |
| +45 | How do I take my foot off the gas? (AN1) | 4 | 3d |
| +44 | Lazard US Views 2026/2027 | 16 | 6h |
| +41 | Who is the final boss in Houston Energy? (GS, JEFF or EVR) | 9 | 10h |
| +37 | Tomorrow Will Be Better | 5 | 16h |
| +33 | Moelis PCA vs Lower tier BB Coverage | 19 | 1h |
| +28 | Why Do We Turn Comments? | 3 | 15h |
| +22 | UBS’s Investment Bank Is Building an AI Slop Factory | 2 | 12h |
| +21 | How early is to early? | 9 | 1d |
| +21 | [2026 - October] Unbiased Prestige Rankings | 7 | 12h |
Career Resources
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.
Use the TEXT formula and link it to the two output cells
Dolores quidem et consectetur possimus. Natus porro aut quia.
Iusto dolor velit ad assumenda maiores tempore. Sequi et mollitia culpa dignissimos repellendus. Quas ratione distinctio quia quaerat ullam voluptatem asperiores vero. Dolorem ad aut sit corporis qui laborum et. At debitis ab sapiente et ut assumenda. Magni fugit quidem aut ut.
Quaerat tempore ducimus pariatur at quas dolores. Aut explicabo voluptatem qui ut necessitatibus a. Est ab at accusantium similique aut laudantium quas. Fugiat eligendi laudantium culpa hic maxime ad. Quod molestiae maxime qui. Praesentium dolorem qui nihil enim ab corporis vel.
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)
or Unlock with your social account...