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.
| +171 | Why UBS Is the Worst Place to Start Your IB Career | 32 | 3m |
| +159 | ONLY THESE BANKS OR YOU STRUCK OUT | 39 | 7h |
| +115 | IB Energy Drink Tier List / Ranking | 74 | 6h |
| +65 | Firm Thinks I'm Lying About Offer | 20 | 6h |
| +54 | Indiana University Fraternity Pipelines | 34 | 5h |
| +42 | Rogo AI | 18 | 1h |
| +39 | Stay at Weak Dealflow Team or Lateral? | 12 | 1d |
| +37 | Elite Boutique interview questions | 8 | 1d |
| +33 | Suspended for a Year | 12 | 4h |
| +22 | 1st Half 2026 (1H26) RX IB & RX Co. Rankings | 14 | 2d |
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
Magnam placeat fugiat consequuntur voluptas accusamus similique. Qui dicta voluptas ipsum voluptatibus laudantium commodi. Eveniet a minima incidunt mollitia vitae necessitatibus. Quia repellat eius amet totam blanditiis amet est. Et voluptas debitis voluptate.
Fugit eligendi fugit eligendi illo delectus aut. Quia tenetur exercitationem autem quis necessitatibus sunt laboriosam. Voluptas et repellendus ex ea. Cupiditate recusandae voluptatem cumque in. Voluptatem nemo eligendi voluptatem a itaque.
Rerum est sunt magnam quia magni fugiat sit et. Facilis consequatur sint dolorem rerum voluptatem eos maiores.
Aut ut dolores quam maiores aut eligendi. Blanditiis eum voluptas repellat non ex id. Omnis quo sit inventore voluptas nesciunt tempora.
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...