Jun 07 2021 03:14 PM
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?
Jun 08 2021 02:45 AM
SolutionJun 08 2021 06:12 AM
Jun 08 2021 02:45 AM
SolutionTry
=IF(ISBLANK(B2:B2000),"",(AL2:AL2000="Not Received")*(AK2:AK2000>60))