I'm trying to apply an array formula to one of my sheets and it is not working - the formula itself works however it isnt being applied to all the cells (the continue bit)
This is my formula.
if(H2-F2<14,1,if(and(H2-F2>14,H2-F2<168),14,if(H2-F2>168,42,"")))
When I add array formula
=ARRAYFORMULA(
if(H2-F2<14,1,
if(and(H2-F2>14,H2-F2<168),14,
if(H2-F2>168,42,"")
)
)
)
It works but doesn't apply it to all cells, why is this and how do I go about making it work?
EDIT: New formula with cell ranges
=ARRAYFORMULA(
if(H2:H-F2:F<14,1,
if(and(H2:H-F2:F>14,H2:H-F2:F<168),14,
if(H2:H-F2:F>168,42,"")
)
)
)