excel函数求教,3个条件中满足3个,任意2个和任意1个,则返回不同值,函数怎么写?比如有ABCD4列,ABC3列单元格显示优秀,一般,较差3个数值,如果3个都是优秀,则D列显示优秀,任意2个优秀,则显示一般,任意1个优秀,则显示较差,没有优秀,则显示很差,这样的函数怎么写?求教大神。
è§æªå¾
D2è¾å ¥
=IF(COUNTIF(A2:C2,"ä¼ç§")=3,"ä¼ç§",IF(COUNTIF(A2:C2,"ä¼ç§")=2,"ä¸è¬",IF(COUNTIF(A2:C2,"ä¼ç§")=1,"è¾å·®","å¾å·®")))
å ¬å¼ä¸æ
公式还可以用:
=CHOOSE(COUNTIF(A2:C2,"优秀")+1,"很差","较差","一般","优秀")
或
=LOOKUP(COUNTIF(A2:C2,"优秀"),{0,1,2,3},{"很差","较差","一般","优秀"})