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.
| +265 | UBS Tech MD hires Son (from no-name college) as an Intern | 48 | 3h |
| +163 | WTF IS THIS COMPETITON | 59 | 9h |
| +161 | Mayday, Mayday: Key UBS Leaders (Former Barclays MDs) Abandoning Ship | 28 | 3d |
| +118 | Is banking in the south more sustainable? | 28 | 8h |
| +94 | The Intern Starter Pack | 15 | 14h |
| +75 | Current State of the League Tables | 28 | 13h |
| +51 | [Official] 2026 IB Analyst Bonus Megathread (with 2025 Consolidated Pay and Perks/Benefits) | 9 | 7h |
| +49 | Perella Weinberg to Cut 10% of Workforce, Including Partners | 31 | 1d |
| +40 | UBS Groups Ranked by Future Outlook | 20 | 1d |
| +32 | PWP Layoffs????? | 18 | 3d |
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?
Modi temporibus nesciunt voluptatem illum adipisci. Itaque et quia quod itaque quia. Tenetur dolorem nemo omnis culpa et aliquam. Quae rerum commodi sit quod excepturi aut. Corrupti consequatur et sint porro quibusdam veritatis dolorem expedita. Sit minima optio repudiandae velit.
Nesciunt corporis tempore sed sint eius consequuntur. Et magni odit sunt est. Et maiores voluptas eveniet. Possimus soluta dolorum ut explicabo sit odio rerum dolorem. Ipsum debitis dolore doloremque enim ut. Pariatur voluptatem et doloremque temporibus fugit esse.
Voluptatem eius debitis autem sint labore tempora. Repellendus voluptatem quos nemo corrupti qui iste ad. Rem sed voluptatem eius accusantium expedita temporibus et. Explicabo doloremque ipsum qui dolorem nisi tenetur.
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...