发布网友 发布时间:2022-04-23 12:42
共1个回答
热心网友 时间:2023-10-13 20:45
=IF(A1-2000<=0,0,IF(A1-2000<=500,(A1-2000)*5%,IF(A1-2000<=2000,(A1-2000)*10%-25,IF(A1-2000<=5000,(A1-2000)*15%-125,IF(A1-2000<=20000,(A1-2000)*20%-375,IF(A1-2000<=40000,((A1-2000)*25%-1375),IF(A1-2000<=60000,(A1-2000)*30%-3375,(A1-2000)*35%-6375)))))))