excel如何对以下的判断计算加函数？ 例 A1小于等于3000，A2＝A1*0.5%;A1小于5000大于3000，A2=A1*1%;
答案:3 悬赏:80 手机版
解决时间 2021-01-07 16:16
- 提问者网友：戎马万世
- 2021-01-07 01:27
excel如何对以下的判断计算加函数？ 例 A1小于等于3000，A2＝A1*0.5%;A1小于5000大于3000，A2=A1*1%;
最佳答案
- 五星知识达人网友：迷人又混蛋
- 2021-01-07 03:02
在A2输入
=IF(A1<=3000,0.005,IF(A1<5000,0.01))*A1追问A1小于等于3000，A2＝A1*0.5%;A1小于5000大于3000，A2=A1*1%;A1小于10000大于5000，A2=A1*1.5%;A1大于10000，A2=A1*2%追答在A2输入
=IF(A1<=3000,0.005,IF(A1<=5000,0.01,IF(A1<=10000,0.015,0.02)))*A1
=IF(A1<=3000,0.005,IF(A1<5000,0.01))*A1追问A1小于等于3000，A2＝A1*0.5%;A1小于5000大于3000，A2=A1*1%;A1小于10000大于5000，A2=A1*1.5%;A1大于10000，A2=A1*2%追答在A2输入
=IF(A1<=3000,0.005,IF(A1<=5000,0.01,IF(A1<=10000,0.015,0.02)))*A1
全部回答
- 1楼网友：摆渡翁
- 2021-01-07 05:16
=IF(A1<=3000,A1*0.5%,IF(AND(A1>3000,A1<5000),A1*1%,""))追问A1小于等于3000，A2＝A1*0.5%;A1小于5000大于3000，A2=A1*1%;A1小于10000大于5000，A2=A1*1.5%;A1大于10000，A2=A1*2%
- 2楼网友：妄饮晩冬酒
- 2021-01-07 04:03
在A2中输入或复制粘贴下列公式
=IF(A1>=3000,A1*0.5%,IF(A1<5000,A1*1%,""))追问A1小于等于3000，A2＝A1*0.5%;A1小于5000大于3000，A2=A1*1%;A1小于10000大于5000，A2=A1*1.5%;A1大于10000，A2=A1*2%
=IF(A1>=3000,A1*0.5%,IF(A1<5000,A1*1%,""))追问A1小于等于3000，A2＝A1*0.5%;A1小于5000大于3000，A2=A1*1%;A1小于10000大于5000，A2=A1*1.5%;A1大于10000，A2=A1*2%
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
大家都在看
推荐资讯