发布网友 发布时间:2024-10-18 03:22
共1个回答
热心网友 时间:2024-11-06 07:39
用if函数吧=IF((A1-3500)>35000,(A1-3500)*0.3-2755,IF((A1-3500)>9000,(A1-3500)*0.25-1005,IF((A1-3500)>4500,(A1-3500)*0.2-555,IF((A1-3500)>1500,(A1-3500)*0.1-105,IF((A1-3500)>0,(A1-3500)*0.3," ")))))