excel中大于49,一等。大于47.5小于等于49,二等。大于46.5且小于等于47.5...答:这个套两个if计算就行,也可以用lookup函数。因为没具体的表格,所以无法给具体的公式。=IF(G21>=500,28.44,IF(G21>=300,30.63,IF(G21>=45,32.82,IF(AND(G21>0,G21<45),43.76,"")))或 =IF(G21="","",LOOKUP(G21,{0,45,300,500},{43.76,32.82,30.63,28.44}))例如...