Using IF AND to filter number in a range, works with dragging, but not in an Array

[mda99das]

I have found a way in Excel (Google Sheets) that filters the ages from 5-9 inclusive. If they fit it , it returns YES otherwise NO



=IF(AND(L1>4, L1<10), "Yes", "No")

I have the ages in column L, and I drag this down to autofill and it works well.

I then used an array formula, that I have used to autofill the column as data is entered

=ArrayFormula( IF(ROW(L:L)=1,"Suitable?", IF(ISBLANK(L:L),"",IF(AND(L:L>4,L:L<10), "Yes", "No"))))

This returns NO all the time
Can someone guide me how to get this to work?

Many thanks