Question about excel custom format used by Macabacus
在输入0或1的单元格中,结果是否或是的,而Excel仍然可以使用单元格进行计算。它们使用数据验证(仅允许0到1之间的值),此自定义格式会导致0和1显示为否,是的:
“是的”)%;“错误”)%;“不”)%;“错误”)%
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.
Comments (3)
I'm pretty sure that it just uses Boolean logic.
类似于使用Sum产品公式并使用“ - - ()”将数组转换为布尔值。
你在谈论ctrl + shift + y对吗?
Placti Odio Libero Voluptas ID。IPSAM Itaque Numquam Molestiae Amet Qui Nisi Vitae Aut。
Velit sit voluptas itaque tempore excepturi est provident. Eveniet nobis mollitia eos non. Omnis et dolores non incidunt ea. Assumenda aut inventore corporis.
Qui ratione cum quia dignissimos molestiae exercitationem accusamus. Quia omnis voluptatem dolores neque. Et est inventore et. Voluptatibus pariatur dolore quas officiis corporis. Qui autem aut velit. Impedit unde consequatur facilis et fugit. Debitis est ad dolor cumque ipsum rerum asperiores optio.
查看所有评论 - 100%免费
WSO取决于他们知道某些东西时的每个人都能够投球。解锁您的电子邮件并获得奖金:6 financial modeling lessons free($199 value)
orWant toUnlock通过与您的社交账户登录?
Preview & download comment as image
You can download this screenshot as image or copy to clipboard using browser's context menu