Rawland Hustle
Reputation: 781
IF statement to ArrayFormula?
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?
Upvotes: 0
Views: 49
Answers (2)
MattKing
Reputation: 7773
=ARRAYFORMULA(IF(B3:B="",,B3:B-ARRAY_CONSTRAIN(B2:B,ROWS(B3:B),1)))
Upvotes: 2
Related Questions
- Google sheets Array Formula IF Statement
- Google Spreadsheet Arrayformula with IF and AND condition
- How to use ArrayFormula in Google Sheets, with multiple IF conditions?
- IF statement to ArrayFormula
- Google Sheet ARRAYFORMULA with IF
- Google Sheets - Using ArrayFormula with Conditional and Embedded Formula
- Add an IF to an arrayformula in Google Sheets
- ArrayFormula with IF Google Sheets
- How to use `If` function in `arrayformula` in Google Spreadsheet?
- Arrayformula If And