EXCEL公式计算:IF(A4=0.5,11,IF(A4>=1,11+(A4-0.5)*9,"F"))当0.5KG=10元 当0.5-20KG,每1KG=3元再加10 当20.5-100KG,每1KG=2元请问函数公式是?第一个公式我也不太懂,尤其是公式中的"F"是啥意思?我还想问:当0.5KG=10
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/17 03:10:36
![EXCEL公式计算:IF(A4=0.5,11,IF(A4>=1,11+(A4-0.5)*9,](/uploads/image/z/1346148-36-8.jpg?t=EXCEL%E5%85%AC%E5%BC%8F%E8%AE%A1%E7%AE%97%EF%BC%9AIF%28A4%3D0.5%2C11%2CIF%28A4%3E%3D1%2C11%2B%28A4-0.5%29%2A9%2C%22F%22%29%29%E5%BD%930.5KG%3D10%E5%85%83+%E5%BD%930.5-20KG%2C%E6%AF%8F1KG%3D3%E5%85%83%E5%86%8D%E5%8A%A010+%E5%BD%9320.5-100KG%2C%E6%AF%8F1KG%3D2%E5%85%83%E8%AF%B7%E9%97%AE%E5%87%BD%E6%95%B0%E5%85%AC%E5%BC%8F%E6%98%AF%3F%E7%AC%AC%E4%B8%80%E4%B8%AA%E5%85%AC%E5%BC%8F%E6%88%91%E4%B9%9F%E4%B8%8D%E5%A4%AA%E6%87%82%2C%E5%B0%A4%E5%85%B6%E6%98%AF%E5%85%AC%E5%BC%8F%E4%B8%AD%E7%9A%84%22F%22%E6%98%AF%E5%95%A5%E6%84%8F%E6%80%9D%3F%E6%88%91%E8%BF%98%E6%83%B3%E9%97%AE%EF%BC%9A%E5%BD%930.5KG%3D10)
xSN@ÊGڅI!p$ [I!"dAx,L_ΔE%v>ιgNr&<],*9n;zI@HAXAiTp]1j&
I1dLtRAP8