请问要满足下面的条件公式怎么编写,我自己编的又有什么问题?当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
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/28 06:07:50
![请问要满足下面的条件公式怎么编写,我自己编的又有什么问题?当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](/uploads/image/z/7336903-31-3.jpg?t=%E8%AF%B7%E9%97%AE%E8%A6%81%E6%BB%A1%E8%B6%B3%E4%B8%8B%E9%9D%A2%E7%9A%84%E6%9D%A1%E4%BB%B6%E5%85%AC%E5%BC%8F%E6%80%8E%E4%B9%88%E7%BC%96%E5%86%99%2C%E6%88%91%E8%87%AA%E5%B7%B1%E7%BC%96%E7%9A%84%E5%8F%88%E6%9C%89%E4%BB%80%E4%B9%88%E9%97%AE%E9%A2%98%3F%E5%BD%93D3%3E37%E6%97%B6%2C%E5%88%99%280.0835%2AD3%2B1.205%29%2A%28100-B3-C3%29%2A0.01%E5%BD%93D3%3D3%2C%E5%88%99D3%2F%280.114%2AD3%2B2.24%29%2A%28100-B3-C3%29%2A0.01%EF%BC%9B%E8%8B%A5G337%2C%280.0835%2AD3%2B1.205%29%2A%28100-B3-C3%29%2A0.01%2CIF%28G3%3E%3D3%2CD3%2F%280.114%2AD3%2B2.24)
请问要满足下面的条件公式怎么编写,我自己编的又有什么问题?当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
请问要满足下面的条件公式怎么编写,我自己编的又有什么问题?
当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
公式看上去没有问题,你这是要问什么
看不懂你这个选股公式最后的条件是什么?是要选出D3>37同时G3>=3的吗?如果是这样,按我下面的写就OK,如果不是,也能从我这里看出思路。
a1:=(0.0835*D3+1.205)*(100-B3-C3)*0.01;
a2:=D3/(0.114*D3+2.24)*(100-B3-C3)*0.01;
a3:=D3/(0.114*D3+2.24)*(100-B3-C3)*0...
全部展开
看不懂你这个选股公式最后的条件是什么?是要选出D3>37同时G3>=3的吗?如果是这样,按我下面的写就OK,如果不是,也能从我这里看出思路。
a1:=(0.0835*D3+1.205)*(100-B3-C3)*0.01;
a2:=D3/(0.114*D3+2.24)*(100-B3-C3)*0.01;
a3:=D3/(0.114*D3+2.24)*(100-B3-C3)*0.01;
a4:=(0.074*D3+2.16)*(100-B3-C3)*0.01);
DD:=if(D3>37,A1,A2);
GG:=IF(G3>=3,A3,A4);
DD=A1 AND GG=A3
收起