Home > Software design >  ARRAYFORMULA does not increase cell as it expands
ARRAYFORMULA does not increase cell as it expands

Time:01-13

I'm trying to get an ARRAYFORMULA to subtract the current cell from the previous one, but it appears that if I write

=ARRAYFORMULA((A3:A)-(A2))

The formula does not increase of one cell as it expands.

here's an example of what I get

enter image description here

enter image description here

  •  Tags:  
  • Related