Hi all,
I’ve been hearing about “Sticky IF-formulas” in excel since business school, but never actually understood what it is. Can someone here explain what a sticky IF is? What is different from a normal IF formula? Is it just a Scenario Analysis using the what-if tab?
Thanks.
| +272 | Why UBS Is the Worst Place to Start Your IB Career | 44 | 1h |
| +220 | UBS 2nd Year Analyst Q&A (2026) | 41 | 2d |
| +154 | Downfall of Qatalyst | 34 | 4s |
| +148 | UBS IB 26Q2 a Disaster! Advisory Revenue Down 23%, Capital MarketsDown 5% | 21 | 4h |
| +108 | What's your craziest "hardo" story? | 18 | 1d |
| +90 | Lincoln International Return Offers | 38 | 1h |
| +57 | Wolf of Wall Street vs. Reality: Anyone else feel scammed by the movies? | 19 | 2d |
| +44 | so confused about 28 SA timeline | 30 | 1d |
| +35 | Rate my non-target resume | 19 | 1d |
| +33 | [WSO MODS] Please Delete This BS Host Books Spam! | 2 | 1d |
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.
Soluta soluta maxime corrupti incidunt ut. Et eius similique voluptas et. Animi doloremque voluptates sequi praesentium.
Quidem labore assumenda dolorem explicabo sapiente qui fugit. Ut reiciendis blanditiis ut quo. Possimus sint iusto repudiandae quod eos.
Expedita provident qui consectetur et quia molestiae deserunt. Vitae reprehenderit libero impedit corrupti impedit. Quo officiis quis quas aut aliquam.
Earum et corporis dolores illum. Autem quo nulla provident nesciunt tempora quam reiciendis. Adipisci ut illum deleniti quia maxime qui. Et non molestias voluptas temporibus.
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...