关于excel表格IF语言的书写求教:大于等于2000为高级,1500-2000之间为中 ...答:假设数字写在A1单元格,则另一单元格写入公式 =IF(A1="","",IF(A1<1500,"初级",IF(A1<2000,"中级","高级")))或 =IF(A1="","",LOOKUP(A1,{0,"初级";1500,"中级";2000,"高级"}))
excel表格如果等于2乘以5,等于大于3乘以10,如数据在D1:H1,怎么写公式...答:=IF(A2=2,A2*5,IF(A2>=3,A2*10,A2))或 =IFS(A2=2,A2*5,A2>=3,A2*10,TRUE,A2)