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...
excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Jun 08, 2021

    IanBradley 

    Try

     

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

HansVogelaar's avatar
HansVogelaar
MVP
Jun 08, 2021

IanBradley 

Try

 

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

  • 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