請版主使用以下公式,檢查一下,哪些股票的專業財務數據的“股東人數”是錯誤的:
股東人數:=
IF(DATE>=1080101 AND DATE<1080401,PFFINON(4253,2008,0401),
IF(DATE>=1080401 AND DATE<1080701,PFFINON(4253,2008,0701),
IF(DATE>=1080701 AND DATE<1081001,PFFINON(4253,2008,1001),
IF(DATE>=1081001 AND DATE<1090101,PFFINON(4253,2009,0101),
IF(DATE>=1090101 AND DATE<1090401,PFFINON(4253,2009,0401),
IF(DATE>=1090401 AND DATE<1090701,PFFINON(4253,2009,0701),
IF(DATE>=1090701 AND DATE<1091001,PFFINON(4253,2009,1001),
IF(DATE>=1091001 AND DATE<1100101,PFFINON(4253,2010,0101),
IF(DATE>=1100101 AND DATE<1100401,PFFINON(4253,2010,0401),
IF(DATE>=1100401 AND DATE<1100701,PFFINON(4253,2010,0701),
IF(DATE>=1100701 AND DATE<1101001,PFFINON(4253,2010,1001),
IF(DATE>=1101001 AND DATE<1110101,PFFINON(4253,2011,0101),
IF(DATE>=1110101 AND DATE<1110401,PFFINON(4253,2011,0401),
IF(DATE>=1110401 AND DATE<1110701,PFFINON(4253,2011,0701),
IF(DATE>=1110701 AND DATE<1111001,PFFINON(4253,2011,1001),
IF(DATE>=1111001 AND DATE<1120101,PFFINON(4253,2012,0101),
IF(DATE>=1120101 AND DATE<1120401,PFFINON(4253,2012,0401),
IF(DATE>=1120401 AND DATE<1120701,PFFINON(4253,2012,0701),
IF(DATE>=1120701 AND DATE<1122001,PFFINON(4253,2012,1001),
IF(DATE>=1121001 AND DATE<1130101,PFFINON(4253,2013,0101),
IF(DATE>=1130101 AND DATE<1130401,PFFINON(4253,2013,0401),
IF(DATE>=1130401 AND DATE<1130701,PFFINON(4253,2013,0701),
IF(DATE>=1130701 AND DATE<1132001,PFFINON(4253,2013,1001),
IF(DATE>=1131001 AND DATE<1140101,PFFINON(4253,2014,0101),
IF(DATE>=1140101 AND DATE<1140401,PFFINON(4253,2014,0401),
IF(DATE>=1140401 AND DATE<1140701,PFFINON(4253,2014,0701),
PFFINON(4253,2014,1001)
))))))))))))))))))))))))));
錯誤:股東人數=0,LINETHICK6,COLOR0000FF;
HHV(錯誤,0);