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.
| +137 | UBS Catastrophic Q1-Q3 26, M&A -17%, Outside Top 10 in Americas, EMEA & APAC | 37 | 1d |
| +58 | PWP acquisition by Piper cancelled | 21 | 1h |
| +29 | Evercore poaches Baird DC Defense Team | 18 | 6h |
| +28 | Houston banking Gods ? | 16 | 2d |
| +21 | Best Houston Banks for Culture in 2026 | 14 | 3h |
| +18 | Normal for lateral process to go +2 months? | 4 | 1d |
| +17 | Internal lateral from coverage to M&A (focused on coverage) | 4 | 11h |
| +15 | How standard is weekend work in IBD? | 6 | 2d |
| +15 | Discussion Transaction Experience in Lateral Interviews | 3 | 3d |
| +15 | Ducera Insights? | 3 | 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.
Excepturi sed ab repudiandae. Dolorum corporis dolorum architecto dolore nemo fugit qui voluptatem. Velit quo sed explicabo tempore qui aut architecto.
Rerum commodi dolor tempore consequatur non. Esse ut rerum qui voluptates beatae reiciendis. Eaque voluptatem quo architecto quibusdam.
Facere consequatur amet reprehenderit ratione quo iusto quis. Ut voluptas sunt et tenetur beatae voluptatibus. Vel suscipit perferendis sit veritatis culpa. Magnam rem et perferendis sit.
Quia tenetur iusto et enim in. Eos maiores voluptas incidunt earum. Aut eos fugit pariatur consequatur veniam beatae doloremque nihil. Provident quibusdam nisi omnis vitae.
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...