<pre id=\"best-answer-content\" class=\"reply-text mb10\">对应C2的公式=IF(C250,8,IF(C2=MAX(C$2:C$6),5,IF(C2=MIN(C$2:C$6),1,3)))
对应C4的公式=IF(C450,8,IF(C4=MAX(C$2:C$6),5,IF(C4=MIN(C$2:C$6),1,3)))
对应C6的公式=IF(C650,8,IF(C6=MAX(C$2:C$6),5,IF(C6=MIN(C$2:C$6),1,3)))
|
