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

Popular posts from this blog

google api - Incomplete response from Gmail API threads.list -

Installing Android SQLite Asset Helper -

Qt Creator - Searching files with Locator including folder -