Forum Discussion

IanBradley's avatar
IanBradley
Copper Contributor
Jun 07, 2021
Solved

Dynamic array formulas and Logic Functions

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?

excel
Formulas and Functions

2 Replies

    • IanBradley's avatar
      IanBradley
      Copper Contributor
      Jun 08, 2021
      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))

Resources