问题描述:
请问要满足下面的条件公式怎么编写,我自己编的又有什么问题?
当D3>37时,则(0.0835*D3+1.205)*(100-B3-C3)*0.01
当D3=3,则D3/(0.114*D3+2.24)*(100-B3-C3)*0.01;
若G337,(0.0835*D3+1.205)*(100-B3-C3)*0.01,IF(G3>=3,D3/(0.114*D3+2.24)*(100-B3-C3)*0.01,(0.074*D3+2.16)*(100-B3-C3)*0.01))
当D3>37时,则(0.0835*D3+1.205)*(100-B3-C3)*0.01
当D3=3,则D3/(0.114*D3+2.24)*(100-B3-C3)*0.01;
若G337,(0.0835*D3+1.205)*(100-B3-C3)*0.01,IF(G3>=3,D3/(0.114*D3+2.24)*(100-B3-C3)*0.01,(0.074*D3+2.16)*(100-B3-C3)*0.01))
问题解答:
我来补答展开全文阅读