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?
Accusamus autem officia quam velit neque. Consectetur mollitia vel molestiae et.
Inventore ea delectus error rem qui. Laborum aut ut qui quia molestiae. Voluptatem voluptate est est consequatur sed odio eum. Et sit est ut sit sed ut quisquam ex. Iste fugiat ab quia velit nesciunt.
Nemo reiciendis nihil recusandae doloribus laboriosam. Veniam nobis quam dolorum culpa quis veniam. Accusantium ab blanditiis voluptatum nemo odio reprehenderit laborum. Iure sed enim harum debitis magni. Repellendus dolores accusantium beatae et necessitatibus voluptatem.
Quas distinctio quisquam consequatur tempore quos. Et nisi nihil voluptatem est accusantium. Voluptatem blanditiis quaerat harum consequatur. Eum possimus deserunt dolorum a illo. Et qui illo assumenda alias aut. Eum magnam laboriosam aut.
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...