Dynamic array formulas and Logic Functions

New Contributor

I just turned my legacy Array Formulae into Dynamic Array Formulae.

I want to use: =IF(ISBLANK(B2:B2000),"",AND(AL2:AL2000="Not Received",AK2:AK2000>60))

but realized that the AND function wants to test for every cell in the array having a value greater than 60, not just the individual cells. How do I refer to the individual cells when using the Dynamic Array?

2 Replies
best response confirmed by IanBradley (New Contributor)




=IF(ISBLANK(B2:B2000),"",(AL2:AL2000="Not Received")*(AK2:AK2000>60))

Thanks, good idea! I wanted the result to express as true/false so modified slightly but this worked:
=IF(ISBLANK(B2:B2000),"",IF((AL2:AL2000="Not Received")*(AK2:AK2000>60),TRUE,FALSE))