IF statement to ArrayFormula?-CodePudding

Home > Net > IF statement to ArrayFormula?

IF statement to ArrayFormula?

Time：09-18

I have a formula in D3 that look like this:

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

How do I fill the whole column D (from D3) with that formula using ArrayFormula?

CodePudding user response：

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

CodePudding user response：

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