第1个回答 2014-05-12
B1公式:
=IF(A1<=0.05,50*A1/0.05,IF(A1<=0.15,(A1-0.05)*50/0.1+50,IF(A1<=0.8,100*(A1-0.15)/0.65+100,"")))
下拉。
第2个回答 2014-05-12
B1:
=IF(a1<=0.05,a1*1000,IF(A1<=0.8,100*(A1-0.15)/0.65+100,IF(A1<=150,(A1-0.05)*50/0.1+50,"未定义")))
第3个回答 2014-05-12
公式如下:
=if(A1<=0.05,50*A1/0.05,if(A1<=0.15,(A1-0.05)*50/0.1+50,100*(A1-0.15)/0.65+100))
第4个回答 2014-05-12
=IF(A1<=0.05,(A1-0.05)*50/0.1+50,IF(A1<=0.8,100*(A1-0.15)/0.65+100,IF(A1<=150,(A1-0.05)*50/0.1+50)))