英文:
IF formula excel-2019
问题
IF(Database!L2="男性, 女性", Database!N2, "")
Salam to every one,
上述公式无法正常工作,我想要从一个工作表获取数据到另一个工作表(如果L2列等于男性或女性,则从N2列获取数据,否则单元格必须为空。
谢谢
英文:
IF(Database!L2="male, female",Database!N2,"")
Salam to every one,
The above formula can't working properly, I want ot get data from one sheet to other sheet( if L2 column equal to male or female get data from N2 column otherwise cell must empty.
Thanks
答案1
得分: 1
=IF(OR(Database!L2="男性",Database!L2="女性"),Database!N2,"")
英文:
Try this
=IF(OR(Database!L2="male",Database!L2="female"),Database!N2,"")
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论