如何在excel中确定取值范围?答:在C1中输入或复制粘贴此公式 =IF(A1+B1>5,5,IF(A1+B1<0,0,A1+B1))或 =IF(A1+B1<0,0,IF(A1+B1>5,5,A1+B1))或 =MIN(MAX(A1+B1,0),5)或 =MAX(MIN(A1+B1,5),0)下拉填充
excel范围内取值?答:D2公式为:=MIN(MAX(C2,VLOOKUP(B2,{"一类",90;"二类",80;"三类",70;"四类",60},2,0)),VLOOKUP(B2,{"一类",100;"二类",90;"三类",80;"四类",70},2,0))示例:公式里面的VLOOKUP(B2,{"一类",90;"二类",80;"三类",70;"四类",60},2,0))计算下限、VLOOKUP(B2,{"一类",...