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}))例如...
EXCEL里想设定个公式,比如当P大于等于60,又小于75的时候,P=0.8,怎么...答:设p的对应值b2单元格,p在c2单元格。则在c2输入:=if(and(b2>=60,b2<85),text(lookup(b2,{60,75,80},{0.8,0.85,1}),"0.0"),"")当不符合条件是,该函数返回空。