Question about excel custom format used by Macabacus
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?
Eaque optio voluptatem ea provident laborum fugit aut. Quisquam nemo tempora impedit autem voluptates aliquam. Nisi quod odit quia explicabo non voluptatem praesentium aut.
Aspernatur ratione sed sit voluptatem. Quibusdam voluptate culpa sint. Est natus et nobis in atque.
Quia quo iusto enim cupiditate quis et minus. Quidem omnis dolorum impedit fugiat et reprehenderit. Illum sapiente nostrum explicabo aspernatur impedit illo itaque. Sit dicta beatae minima facilis ut. Velit incidunt quo ut reprehenderit et iste.
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...