问题描述
我需要以下数组作为日期类型:
= IF(OR(A2:C2 =Mar 12 ),1,0)
查看样本数据,在列EI中,需要一个数组公式,查找列B到D,并搜索包含5月12日的结果并显示true或false (1或0)。
= IF(SUM((MONTH(A2:C2)= 5)*(YEAR(A2:C2)= 2013))> 0 ,1,0)
,但按 + + 而不是通常的 - 这将定义一个ARRAY公式,并将导致 {}
括号AR ound it(但不要手动输入!)
根据需要指定月份和年份
I need the following array for a Date type:
=IF(OR(A2:C2="Mar 12"),1,0)
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:
=IF(SUM((MONTH(A2:C2)=5)*(YEAR(A2:C2)=2013))>0,1,0)
but press ++ instead of usual - this will define an ARRAY formula and will result in {}
brackets around it (but do NOT type them manually!).
Specify month and year as you wish)
这篇关于带有日期的Microsoft Excel数组公式的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!