google spreadsheet - Arrayformula If And -
i'm trying apply array formula 1 of sheets , not working - formula works isnt being applied cells (the continue bit)
this formula.
if(h2-f2<14,1,if(and(h2-f2>14,h2-f2<168),14,if(h2-f2>168,42,"")))
when 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 doesn't apply cells, why , how go making work?
edit: new formula 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,"") ) ) )
i'm not sure why doesn't work either, work around break each of conditions in 'and' statement separate nested 'if' statements. if have 3 conditions, end 3 if statements 1 nested inside other:
if(condition_1, if(condition_2, if(condition_3,then x,else y),else y),else y)
it's equivalent if + , statement
Comments
Post a Comment