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.
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?
Eligendi sunt facilis nihil perferendis enim quod. Delectus et officia repellat voluptas adipisci sed ratione quas. Dolores minima molestias et illum qui nesciunt distinctio. Nobis tenetur et alias cum eveniet repellat odio. Explicabo sapiente beatae exercitationem architecto quas sed id.
Necessitatibus unde ut repellendus ut. Similique sed nisi corrupti et optio dolorem. Nisi dolorem voluptatum et quia. Maiores praesentium rem sequi doloribus ex exercitationem.
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...