Forum Discussion

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

Jul 23, 2023

Alternative

= LET(
    s, BYROW(data, LAMBDA(d, MAX(SUM(d), 0))),
    VSTACK(s, SUM(s))
  )

Yousef70

Brass Contributor

Jul 22, 2023

Dear Riny ...

thank you for your help ...

I have inserted the formula you sent to me but it did not work
cell O18 is +10
cell P18 is -214.730
result cell still at 0.000

only when cell O18 exceed -214.730 result cell will give positive deference

looking forward to your help again

Riny_van_Eekelen

Platinum Contributor

Jul 22, 2023

Yousef70 What should be the result then? And why?

Yousef70
Brass Contributor
Jul 22, 2023
Dear Riny ...

thanks for your help

i have tried the following and it did work

=max(0,O18,P18,sum(O18:P18))

it did give the needed result of one or ether sum of positive cells

Thank you Sir you have been very helpful
- Riny_van_Eekelen
  Platinum Contributor
  Jul 22, 2023
  Yousef70 GReat, though I don't understand that formula.
  - Yousef70
    Brass Contributor
    Jul 22, 2023
    Dear Riny
    
    however , it did not work on more than two cells as follows :
    =MAX(0,O6,O7,O8,O9,O10,O11,O12,O13,O14,O15,O16,O17,O18,O19,,O20,O21,O22,O23,O24,O25,O26,O27,O28,O29,O30,O31,O32,O33,O34,O35,O36,SUM(O6:O36))
    
    it did only give 1 positive cell result not a sum ( the highest of positive cells not a sum of positive cells )
    
    -1232.200
    
    -1013.200
    
    573.200
    
    620.000
    
    result cell 620.000















	-1232.200




	-1013.200




	573.200




	620.000

result cell	620.000