求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/12/26 00:26:06
求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),"有货","无货")