Forum Discussion

Yousef70's avatar
Yousef70
Brass Contributor
Jul 19, 2023
Solved

If formula

Dear Sirs …. Kindly need your help with below table to distinguish between + or - numbers in the result cell to take + value cell keep in mind the following If formula used in result cell ( if there...
microsoft 365
  • PeterBartholomew1's avatar
    PeterBartholomew1
    Jul 23, 2023

    Alternative

    = LET(
    s, BYROW(data, LAMBDA(d, MAX(SUM(d), 0))),
    VSTACK(s, SUM(s))
  )
PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
Jul 23, 2023

Yousef70 

A nice thing about 365 is that it has very little in common with traditional spreadsheet practice :stareyes:

= LET(
    t, BYROW(data,
      LAMBDA(d,
        LET(
          s, SUM(d),
          IF(s>0, s, 0)
        )
      )
    ),
  VSTACK(t, SUM(t))
  )

 

 

PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
Jul 23, 2023

Alternative

= LET(
    s, BYROW(data, LAMBDA(d, MAX(SUM(d), 0))),
    VSTACK(s, SUM(s))
  )
  • Yousef70's avatar
    Yousef70
    Brass Contributor
    Jul 25, 2023
    Dear Peter …

    Many thanks for your input

    I didn't get the chance to implement the above coding , I will ASAP and inform you about the results

Resources