Forum Discussion

Tegzi's avatar
Tegzi
Copper Contributor
Jun 30, 2023
Solved

Max function for Spilled Range

Hello,   I am struggling to resolve the following. With DA (Dynamic Array) formulas I calculate 3 columns: App: =IF(D7=1,INDEX(SORTBY($AF$15#,$AG$15#,-1),SEQUENCE(AJ11)),INDEX(SORTBY($AF$15#,$AG$1...
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Jun 30, 2023

    Tegzi 

    As variant

    =IF( B2# > C2#, B2#, C2#)
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jun 30, 2023

Tegzi 

As variant

=IF( B2# > C2#, B2#, C2#)
Peter1979's avatar
Peter1979
Copper Contributor
Mar 08, 2024

SergeiBaklan   Do we have any idea why MAX doesn't spill?  Do we know which functions spill and which don't?