In cells where you input either 0 or 1, the result is no or yes, while excel can still use the cell to make calculations with. They use data validation (only allow values between 0 to 1) and this custom format results in 0 and 1 being displayed as no and yes:
"Yes"_)_%;"ERROR"_)_%;"No"_)_%;"ERROR"_)_%
Anybody who could walk me through how one should interpret that and how that links to the values 0 and 1? I cannot find a custom format in excel that is already set up like that.
| +253 | Investment Banks Ranked By Your Divorced Blue Collared Uncle | 23 | 2h |
| +148 | UBS Exits 2026 | 39 | 1d |
| +96 | Work life balance = highly overrated | 38 | 3h |
| +74 | Congrats on the ROs. I Still Don’t Know Which One You Were | 8 | 2d |
| +42 | Did not get a return offer due to headcount, but happy to move on. | 8 | 2d |
| +40 | IB RO Discussion | 8 | 1d |
| +34 | I don’t think investment banking is the way for me anymore | 29 | 1h |
| +30 | Case studies in banking interviews? | 3 | 1h |
| +29 | Getting a BB job just for brand name? | 5 | 1d |
| +29 | Lied about bonus to future employer | 17 | 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.
I’m pretty sure that it just uses Boolean logic.
Similar to when you use a sum product formula and convert the array to Boolean using “ - - ( )”.
You’re talking about ctrl + shift + y right?
Consequatur eum quaerat consequatur et laudantium. Amet quas officiis dolor beatae. Itaque suscipit qui itaque vitae reprehenderit molestiae.
A ut temporibus nam quo voluptate. Sequi magnam libero neque officiis. Minima ex dolore debitis ut odio porro amet.
Aliquid temporibus enim similique autem sequi. Vitae vero maiores et id veniam assumenda accusamus eveniet. Consectetur ab consequuntur in sunt quia quasi corporis et. Qui sed minima possimus consequatur repudiandae voluptatem qui. Minus repellat pariatur officiis laudantium deleniti non perferendis.
Voluptatum consequatur et error. Molestias est consequatur illum. Veniam cumque expedita neque cumque aliquid non. Officiis libero voluptatem ipsum.
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...