求if函数公式我自己列的公式不成立d21=if(c3-d3>0,c6-d6>0,c9-d9>0,c12-d12>0,c15-d15>0,c18-d18>0,"有货","无货")e21=if(c3-d3-e3>0,c6-d6-e6>0,c9-d9-e9>0,c12-d12-e12>0,c15-d15-e15>0,c18-d18-18>0,"有货","无货")f21=if(c3
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/02 12:47:44
![求if函数公式我自己列的公式不成立d21=if(c3-d3>0,c6-d6>0,c9-d9>0,c12-d12>0,c15-d15>0,c18-d18>0,](/uploads/image/z/2735988-60-8.jpg?t=%E6%B1%82if%E5%87%BD%E6%95%B0%E5%85%AC%E5%BC%8F%E6%88%91%E8%87%AA%E5%B7%B1%E5%88%97%E7%9A%84%E5%85%AC%E5%BC%8F%E4%B8%8D%E6%88%90%E7%AB%8Bd21%EF%BC%9Dif%EF%BC%88c3-d3%3E0%2Cc6-d6%3E0%2Cc9-d9%3E0%2Cc12-d12%3E0%2Cc15-d15%3E0%2Cc18-d18%3E0%2C%22%E6%9C%89%E8%B4%A7%22%2C%22%E6%97%A0%E8%B4%A7%22%EF%BC%89e21%EF%BC%9Dif%EF%BC%88c3-d3-e3%3E0%2Cc6-d6-e6%3E0%2Cc9-d9-e9%3E0%2Cc12-d12-e12%3E0%2Cc15-d15-e15%3E0%2Cc18-d18-18%3E0%2C%22%E6%9C%89%E8%B4%A7%22%2C%22%E6%97%A0%E8%B4%A7%22%EF%BC%89f21%EF%BC%9Dif%EF%BC%88c3)
求if函数公式我自己列的公式不成立d21=if(c3-d3>0,c6-d6>0,c9-d9>0,c12-d12>0,c15-d15>0,c18-d18>0,"有货","无货")e21=if(c3-d3-e3>0,c6-d6-e6>0,c9-d9-e9>0,c12-d12-e12>0,c15-d15-e15>0,c18-d18-18>0,"有货","无货")f21=if(c3
求if函数公式
我自己列的公式不成立
d21=if(c3-d3>0,c6-d6>0,c9-d9>0,c12-d12>0,c15-d15>0,c18-d18>0,"有货","无货")
e21=if(c3-d3-e3>0,c6-d6-e6>0,c9-d9-e9>0,c12-d12-e12>0,c15-d15-e15>0,c18-d18-18>0,"有货","无货")
f21=if(c3-d3-e3-f3>0,c6-d6-e6-f6>0,c9-d9-e9-f9>0,c12-d12-e12-f12>0,c15-d15-e15-f15>0,c18-d18-e18-f18>0,"有货","无货")
`````
这个公式能成立 可是太长了
这个公式不能简化吗?D21=IF(AND(C3-D3>0,C6-D6>0,C9-D9>0,C12-D12>0,C15-D15>0,C18-D18>0),"有货","无货")
E21=IF(AND(C3-D3-E3>0,C6-D6-E6>0,C9-D9-E9>0,C12-D12-E12>0,C15-D15-E15>0,C18-D18-E18>0),"有货","无货")
F21=IF(AND(C3-D3-E3-F3>0,C6-D6-E6-F6>0,C9-D9-E9-F9>0,C12-D12-E12-F12>0,C15-D15-E15-F15>0,C18-D18-E18-F18>0),"有货","无货")
G21=IF(AND(C3-D3-E3-F3-G3>0,C6-D6-E6-F6-G6>0,C9-D9-E9-F9-G9>0,C12-D12-E12-F12-G12>0,C15-D15-E15-F15-G15>0,C18-D18-E18-F18-G18>0),"有货","无货")
H21=IF(AND(C3-D3-E3-F3-G3-H3>0,C6-D6-E6-F6-G6-H6>0,C9-D9-E9-F9-G9-H9>0,C12-D12-E12-F12-G12-H12>0,C15-D15-E15-F15-G15-H15>0,C18-D18-E18-F18-G18-H18>0),"有货","无货")
求if函数公式我自己列的公式不成立d21=if(c3-d3>0,c6-d6>0,c9-d9>0,c12-d12>0,c15-d15>0,c18-d18>0,"有货","无货")e21=if(c3-d3-e3>0,c6-d6-e6>0,c9-d9-e9>0,c12-d12-e12>0,c15-d15-e15>0,c18-d18-18>0,"有货","无货")f21=if(c3
以d21为例,公式应该是:
=IF(AND(C3-D3>0,C6-D6>0,C9-D9>0,C12-D12>0,C15-D15>0,C18-D18>0),"有货","无货")