=IF(B10=MAX(B:B),10,IF(B10=MIN(B:B),6,ROUND((B10-MIN(B:B))/(MAX(B:B)-MIN(B:B))*4+6,1)))是不是这么理解
如果数据在B2:B15=(B2-MIN(B$2:B$15))*(10-6)/(MAX(B$2:B$15)-MIN(B$2:B$15))
