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.
| +211 | UBS Accused of Favoring H-1B Workers While Cutting U.S.-Born Employees | 51 | 8h |
| +109 | IB Energy Drink Tier List / Ranking | 72 | 16h |
| +103 | ONLY THESE BANKS OR YOU STRUCK OUT | 31 | 1h |
| +91 | PJT M&A Group Selection 2026 | 14 | 13h |
| +51 | Feedback for internship first desk at IBD BB - personal fit, "don't be too confident" | 29 | 15h |
| +46 | Firm Thinks I'm Lying About Offer | 18 | 5h |
| +31 | Stay at Weak Dealflow Team or Lateral? | 7 | 17h |
| +29 | Does BofA still pay its associates rat pellets? | 15 | 10h |
| +26 | Rogo AI | 6 | 2h |
| +22 | Indiana University Fraternity Pipelines | 13 | 13h |
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?
Quos expedita iste maxime officia earum iste. Asperiores dolores ut exercitationem omnis tenetur et sint. Temporibus fugiat est provident et suscipit. Alias velit ut alias fugiat eligendi.
Sapiente deleniti et nisi nesciunt est autem rerum. Molestiae dolorum incidunt cupiditate eius vero atque id. Dolorem veniam dolorem voluptas temporibus sapiente. Qui culpa quia tempora sit voluptas minus alias.
Quos et aut eum repudiandae earum. Iure sed doloremque et voluptatem harum eius.
Dignissimos molestias animi fuga et sed nemo. Non alias delectus corrupti reprehenderit velit cupiditate. Facere delectus voluptas deleniti exercitationem repellendus ipsum. Cumque quae et praesentium est quia. Quo enim distinctio nam officia sunt et.
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...