求用电子表格函数制作单价公式,条件如下=5000,单价850(含税),>=5000每超1K单价上调0.17元;4800-500上面的条件没打完,这个是全的:保5000K,价850(含税),每超1K上调0.17元;4800-5000K,扣0.17元/K,4600
来源:学生作业帮助网 编辑:作业帮 时间:2024/08/15 18:17:15
![求用电子表格函数制作单价公式,条件如下=5000,单价850(含税),>=5000每超1K单价上调0.17元;4800-500上面的条件没打完,这个是全的:保5000K,价850(含税),每超1K上调0.17元;4800-5000K,扣0.17元/K,4600](/uploads/image/z/2989377-9-7.jpg?t=%E6%B1%82%E7%94%A8%E7%94%B5%E5%AD%90%E8%A1%A8%E6%A0%BC%E5%87%BD%E6%95%B0%E5%88%B6%E4%BD%9C%E5%8D%95%E4%BB%B7%E5%85%AC%E5%BC%8F%2C%E6%9D%A1%E4%BB%B6%E5%A6%82%E4%B8%8B%3D5000%2C%E5%8D%95%E4%BB%B7850%EF%BC%88%E5%90%AB%E7%A8%8E%EF%BC%89%2C%3E%3D5000%E6%AF%8F%E8%B6%851K%E5%8D%95%E4%BB%B7%E4%B8%8A%E8%B0%830.17%E5%85%83%EF%BC%9B4800-500%E4%B8%8A%E9%9D%A2%E7%9A%84%E6%9D%A1%E4%BB%B6%E6%B2%A1%E6%89%93%E5%AE%8C%2C%E8%BF%99%E4%B8%AA%E6%98%AF%E5%85%A8%E7%9A%84%EF%BC%9A%E4%BF%9D5000K%2C%E4%BB%B7850%EF%BC%88%E5%90%AB%E7%A8%8E%EF%BC%89%2C%E6%AF%8F%E8%B6%851K%E4%B8%8A%E8%B0%830.17%E5%85%83%EF%BC%9B4800-5000K%2C%E6%89%A30.17%E5%85%83%2FK%2C4600)
x){ϧl}v+-}ﳩvl{wީOvoں~gs>ٽ鲦';mM
t t<{:uj
QdG
zO[mba`T9wY-ßmZsu=:/|cճ럶 J3 suX 5@]:CuLl>X/ l .H&nW61I%z6v6#>{h8TJR$aỲZ^BSDjlbT tqAb(?
求用电子表格函数制作单价公式,条件如下=5000,单价850(含税),>=5000每超1K单价上调0.17元;4800-500上面的条件没打完,这个是全的:保5000K,价850(含税),每超1K上调0.17元;4800-5000K,扣0.17元/K,4600
求用电子表格函数制作单价公式,条件如下
=5000,单价850(含税),>=5000每超1K单价上调0.17元;4800-500
上面的条件没打完,这个是全的:保5000K,价850(含税),每超1K上调0.17元;4800-5000K,扣0.17元/K,4600-4800K,扣0.18元/K ;4200-4600K,扣0.2元/K.
求用电子表格函数制作单价公式,条件如下=5000,单价850(含税),>=5000每超1K单价上调0.17元;4800-500上面的条件没打完,这个是全的:保5000K,价850(含税),每超1K上调0.17元;4800-5000K,扣0.17元/K,4600
=LOOKUP(A1,{4200,849.8;4600,849.82;4800,849.83;5000,850})+MAX(,INT((A1-5000)/1000)*0.17)
试试.