问题描述
我需要以下数组作为日期类型:
= IF(OR(A2:C2 =Mar 12 ),1,0)
样本数据 查看样本数据,在列EI中,需要一个数组公式,查找列B到D,并搜索包含5月12日的结果并显示true或false (1或0)。 我认为这将满足您的需求 - 输入D2: ,但按 + + 而不是通常的 - 这将定义一个ARRAY公式,并将导致 根据需要指定月份和年份 I need the following array for a Date type: Sample Datahttps://docs.google.com/spreadsheet/ccc?key=0AhoDU0OTM87sdHR3RGw3NTJacEV1OEt5OWZTWTBYUFE&usp=sharing Looking at the sample data, in Column E I want an array formula that would look into columns B to D and search for results that contain 'May 12' and display true or false (1 or 0) in column E. I think this will meet your needs - type in D2: but press ++ instead of usual - this will define an ARRAY formula and will result in Specify month and year as you wish) 这篇关于带有日期的Microsoft Excel数组公式的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!
= IF(SUM((MONTH(A2:C2)= 5)*(YEAR(A2:C2)= 2013))> 0 ,1,0)
{}
括号AR ound it(但不要手动输入!)
=IF(OR(A2:C2="Mar 12"),1,0)
=IF(SUM((MONTH(A2:C2)=5)*(YEAR(A2:C2)=2013))>0,1,0)
{}
brackets around it (but do NOT type them manually!).