如截图所示,看着有点复杂,但是本质逻辑是比较清晰的。最后富文本呈现的结果有问题,但是不知道哪里出了错误。 跑数结果如下: 富文本内容: 【销量】${=if(AO17="","","环比↓:" )}${=if(AO17="","",C17)}${=if(AO18="",""," > " )}${=if(AO18="","",C18)}${=if(AO19="",""," > " )}${=if(AO19="","",C19)}${=if(AP17="","","同比↓:" )}${=if(AP17="","",D17)}${=if(AP18="",""," > " )}${=if(AP18="","",D18)}${=if(AP19="",""," > " )}${=if(AP19="","",D19)}【库存周转】${=if(AQ17="","","高周转:" )}${=if(AQ17="","",E17)}${=if(AQ18="",""," > " )}${=if(AQ18="","",E18)}${=if(AQ19="",""," > " )}${=if(AQ19="","",E19)}${=if(AR17="","","环比↑:" )}${=if(AR17="","",F17)}${=if(AR18="",""," > " )}${=if(AR18="","",F18)}${=if(AR19="",""," > " )}${=if(AR19="","",F19)}【退货率】${=if(AS17="","","高退货:" )}${=if(AS17="","",G17)}${=if(AS18="",""," > " )}${=if(AS18="","",G18)}${=if(AS19="",""," > " )}${=if(AS19="","",G19)}${=if(AT17="","","环比↑:" )}${=if(AT17="","",H17)}${=if(AT18="",""," > " )}${=if(AT18="","",H18)}${=if(AT19="",""," > " )}${=if(AT19="","",H19)} |