优先级:红色预警>橙色预警>黄色预警,T3:W3单元格根据优先级,依次返回预警类型,我在excel里写了个:=IF(COUNTIF(T3:W3,"红色预警"),"红色预警",IF(COUNTIF(T3:W3,"橙色预警"),"橙色预警",IF(COUNTIF(T3:W3,"黄色预警"),"黄色预警",""))),但帆软不支持countif函数,用的8.0,请大家提供些思路,感谢感谢!!
if(INARRAY("红色预警",b2:e2)>0,"红色预警",if(INARRAY("橙色预警",b2:e2)>0,"橙色预警",if(INARRAY("黄色预警",b2:e2)>0,"黄色预警","")))