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))
  )

 

 

Yousef70's avatar
Yousef70
Brass Contributor
Jul 25, 2023

Dear Peter …

In the above coding , can you give an alternative to result column positive cell amount even if negative cell amount is higher ?

for example in above table:-
column 1 column 2 result
10 -214 10
20 5 25
-45 60 60
15 -60 15
110

as per I am looking for the "honored" payments ( positive cells ) but still need to acknowledge the "not honored" payments ( negative cells ) but not in the result cell

many thanks in advance

Resources