=IFYEARSheet2!AA=YEARSheet2!BBYEARSheet2!AAYEARSheet2!Sheet2!AA&-&YEARSheet2!Sheet2!BB这个函数有错误吗

有错误。应该是：

=IF(YEAR(Sheet2!A:A)=YEAR(Sheet2!B:B),YEAR(Sheet2!A:A),YEAR(Sheet2!A:A)&"-"&YEAR(Sheet2!B:B))

原文地址: http://www.cveoy.top/t/topic/dHCt 著作权归作者所有。请勿转载和采集!