如何使用更多简洁的IF- Excel
我正在尝试在B列中搜索许多单元格以获取数字1。当找到1时，我想在找到1的行的A列中显示该值。我对Excel公式非常新鲜，但这是我尝试的：
= Ifs（'8＆amp; wuster'！b3 = 1，'8＆amp; puffer'！ '！a4，'8＆puffer'！b5 = 1，'8＆amp; wuster'！ '8＆amp;在'！ b10 = 1，'8＆amp;在'！a10，'8＆nuffer'！b11 = 1，'8＆niffer'！a11）上
工作，但我需要多次重新创建它申请工作。
谢谢。
I'm trying to search many cells in the B column for the number 1. When the 1 is found, I want to display the value in the A column of the row in which the 1 was found. I am very new to excel formulas, but this is what I tried:
=IFS('8&Under'!B3=1,'8&Under'!A3,'8&Under'!B4=1,'8&Under'!A4,'8&Under'!B5=1,'8&Under'!A5,'8&Under'!B6=1,'8&Under'!A6,'8&Under'!B7=1,'8&Under'!A7,'8&Under'!B8=1,'8&Under'!A8,'8&Under'!B9=1,'8&Under'!A9,'8&Under'!B10=1,'8&Under'!A10,'8&Under'!B11=1,'8&Under'!A11)
It works, but is horribly long, and I will need to recreate it many times for the whole application to work out.
Thanks.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
您可能需要使用过滤器根据匹配条件
https://support.microsoft.com/en-us/office/filter-function-function-function-f4f7cb66-82eb-4767-8f7c-487c-48777ad80c759
You may want to use FILTER to dynamically show a range based on matching criteria
https://support.microsoft.com/en-us/office/filter-function-f4f7cb66-82eb-4767-8f7c-4877ad80c759
您可以使用
任一个函数normal函数=（b2 = 1，“找到数字1”，“”）
范围函数= if（b2：b27 = 1，“找到数字1”，“”）
you can use either function
Normal function =IF(B2=1,"Found the number 1","")
Range function =IF(B2:B27=1,"Found the number 1","")