=IF(AND(H4="",I4=""),"",(SUM(H$4:H4)-SUM(I$4:I4))+$J$3)是什么意思
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/07 10:08:26
![=IF(AND(H4=](/uploads/image/z/5088879-63-9.jpg?t=%3DIF%28AND%28H4%3D%22%22%2CI4%3D%22%22%29%2C%22%22%2C%28SUM%28H%244%3AH4%29-SUM%28I%244%3AI4%29%29%2B%24J%243%29%E6%98%AF%E4%BB%80%E4%B9%88%E6%84%8F%E6%80%9D)
xRN@ÂteĘn`@塃+<<4!V{e/xK
aF6;g=ܛw#XO݂xnǮEE]DZdcJY4»))o(h.b3aPcQ2Z4Ya}b}D)uUL%ĠU+NܤaE4sQ 1zC7j-_ƾy[ͧf;^[/@:k91qǡ:,.҃dbБʟf{tV<<0
~wnޙǫmD+PkдLi_+.$nPoW/YvpgޒғČN 2Kġ::0+&02tz?Ɔ
=IF(AND(H4="",I4=""),"",(SUM(H$4:H4)-SUM(I$4:I4))+$J$3)是什么意思
=IF(AND(H4="",I4=""),"",(SUM(H$4:H4)-SUM(I$4:I4))+$J$3)是什么意思
=IF(AND(H4="",I4=""),"",(SUM(H$4:H4)-SUM(I$4:I4))+$J$3)是什么意思
这是个求实时余额(或结存数)的公式,J3为期初余额,H列为增加方,I列为减少方.
公式的意思就是如果H、I两列都为空(即都没填入发生额时),余额列(即公式所在单元格)显示为空,否则返回的结果为,H列从第4行开始至本行(公式所在行)的合计减去I列从第4行开始至本行的合计,再加上期初余额.
=IF(AND(H4="",I4=""),"",(SUM(H$4:H4)-SUM(I$4:I4))+$J$3)应该是输入在J4单元格,然后下拉复制到J列其它单元格.