求助函数公式
答案:3 悬赏:30 手机版
解决时间 2021-03-20 03:40
- 提问者网友：最美的风景
- 2021-03-19 11:46
求助函数公式
最佳答案
- 五星知识达人网友：慢性怪人
- 2021-03-19 12:36
若以“起始分”单元格为A1，那么在C2单元格输入以下公式
=SUM(TEXT(B2-{0,2000,3000,3500,4000,4200,4500,4800},"0.0;!0")*{0.45,0.03,0.07,0.05,0.05,0.05,0.10,0.20})-SUM(TEXT(A2-{0,2000,3000,3500,4000,4200,4500,4800},"0.0;!0")*{0.45,0.03,0.07,0.05,0.05,0.05,0.10,0.20})追问这个貌似错误追答请提供行号和列标的截图，以方便判断。
=SUM(TEXT(B2-{0,2000,3000,3500,4000,4200,4500,4800},"0.0;!0")*{0.45,0.03,0.07,0.05,0.05,0.05,0.10,0.20})-SUM(TEXT(A2-{0,2000,3000,3500,4000,4200,4500,4800},"0.0;!0")*{0.45,0.03,0.07,0.05,0.05,0.05,0.10,0.20})追问这个貌似错误追答请提供行号和列标的截图，以方便判断。
全部回答
- 1楼网友：春色三分
- 2021-03-19 13:56
试试
=LOOKUP(B3,B5:B100,D5:D100)追问这个只能找到多少钱/分
=LOOKUP(B3,B5:B100,D5:D100)追问这个只能找到多少钱/分
- 2楼网友：你可爱的野爹
- 2021-03-19 13:40
这个问题没有说清：如果起始是1000，目标分是3100，又应按什么要求如何计算？
我要举报
如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
点此我要举报以上问答信息
大家都在看
推荐资讯