发布网友 发布时间:2022-04-23 19:27
共1个回答
热心网友 时间:2023-09-09 11:04
最近三年毛利率连续大于30%的股:
CURYEAR:=IF(MONTH>=4,YEAR,YEAR-1);
YEAR1:=CURYEAR-1;
YEAR2:=CURYEAR-2;
YEAR3:=CURYEAR-3;
毛利率1:=(1-FINONE(75,YEAR1,1231)/FINONE(74,YEAR1,1231))*100;
毛利率2:=(1-FINONE(75,YEAR2,1231)/FINONE(74,YEAR2,1231))*100;
毛利率3:=(1-FINONE(75,YEAR3,1231)/FINONE(74,YEAR3,1231))*100;
毛利率1>30 AND 毛利率2>30 AND 毛利率3>30;