比如说:当A1大于等于450时,A2单元格的值为1,当A1大于450小于等于1000时,A2单元格的值为2,当A1大于1000小于等于1500时,A2单元格的值为3。如何设定公式的条件?
当A1为空值时A2为1,怎么让他空值时不显示?
A2=IF(A1=0,"",IF(A1<=450,"1",IF(A1<=1000,"2",IF(A1<=1500,"3","超出范围值"))))
我是了,显示 超出范围值