IF statement to ArrayFormula?



我在D3中有一个公式,看起来像这样:

=IF(B3="","",B3-B2)

我如何填写整个列D(从D3)与该公式使用ArrayFormula?

=ARRAYFORMULA(IF(B3:B="",,B3:B-ARRAY_CONSTRAIN(B2:B,ROWS(B3:B),1)))

=ARRAYFORMULA(IF(B3:B501="","",B2:B500-B3:B501))

最新更新