...b=a+2,a大于5小于等于10 b=a+4, a小于10大于等于20 b=a+6_百度...答:B1 =IF(A1<=5,A1+2,IF(AND(A1>5,A1<=10),A1+4,IF(AND(A1>10,A1<=20),A1+6,"")))大于20时为空白 简化公式为 B1 =IF(A1<=5,A1+2,IF(A1<=10,A1+4,IF(A1<=20,A1+6,"")))
excel 函数,如B2大于B1,显示"上“;B2等于B1,显示"中";B2小于B1,显示...答:=IF(B2>B1,"上",IF(B2=B1,"中","下"))或者 =CHOOSE(SIGN(B2-B1)+2,"下","中","上")