Microsoft Office Forums - View Single Post - Using IF AND to filter number in a range, works with dragging, but not in an Array

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

View Single Post

Old

11-17-2022, 01:12 PM

mda99das

mda99das is offline

mda99das uses Windows 7 64bit

Windows 7 64bit mda99das uses Office 2013

mda99das uses Office 2013

Office 2013

Novice

The original poster

Join Date: Oct 2022

Posts: 12

mda99das is on a distinguished road

Default

Its the AND function in an array,

to get it to work

=ArrayFormula( IF(ROW(L:L)=1,"rej", IF(ISBLANK(L:L),"",IF((L:L<10)*(L:L>4), "Yes", "No"))))

Reply With Quote