蒸蒸对美女的定义为,假如她呢,不是著姐,而且要美貌如花,燕语莺声,温柔善良,长发飘飘,那她就是大家公认的美女。否则呢,她就是一片空白,被大家所忽略。下面是设置的公式,结果呢出现了错误值,为什么呢?公式如下,请大家帮我修改!
=IF(AND(A1<>"著姐",A1=AND("美貌如花","燕语莺声","温柔善良","长发飘飘")),"美女","")
=IF(OR(A1<>"著姐",A1={"美貌如花","燕语莺声","温柔善良","长发飘飘"}),"女","")
使用道具 举报
长得像数组……
数组公式,学习……
风雨云,你在贴个不是数组的公式!
本版积分规则 发表回复 回帖后跳转到最后一页
小黑屋|手机版|Archiver|Excel精英培训 ( 豫ICP备11015029号 )
GMT+8, 2024-4-19 09:41 , Processed in 0.306977 second(s), 9 queries , Gzip On, Yac On.
Powered by Discuz! X3.4
Copyright © 2001-2020, Tencent Cloud.