excel表格公式若A1数值小于3500时乘以0.033 若大于等于3500小于4000时乘以0.035

Question

excel表格公式若A1数值小于3500时乘以0.033 若大于等于3500小于4000时乘以0.035 大于等于4000小于4500时乘以0.036 大于等于4500时乘以0.037 公式怎么设置？？ 急急急

Answer 1

=IF(A1>=4500,A1*0.037,IF(A1>=4000,A1*0.036,IF(A1>=3500,A1*0.035,A1*0.033)))

Answer 2

=IF(A1<3500,0.033,IF(A1<4000,0.035,IF(A1<4500,0.036,0.037)))*A1