4楼的答案在L2大于等于H2上有点小错误,应该为:=IF(L2=E2,A,IF(and(L2E2,L2=H2),B,IF(And(L2H2,L2=K2),C,IF(L2k2,D,))))<span class=\\\"evaluate\\\" id=\\\"evaluate-1278980035\\\" ><span class=\\\"evaluate-outer\\\"><span class=\\\"evaluate-inner\\\"><b class=\\\"evaluate-tip\\\" style=\\\"display:none\\\">赞同</b><span><b class=\\\"evaluate-num evaluate-num-fixed\\\">0</b></span></span></span></span><span class=\\\"f-pipe\\\">|</span><span class=\\\"comment\\\" id=\\\"comment-1278980035\\\">评论</span>
|