Nov 12 2021 01:16 AM
HI, how can I write a condition, if x + y <0 then value is simply x+y, but if x + y >0 then make it zero
Nov 12 2021 01:26 AM
=IF(A1+B1<0,A1+B1,0)
Is this what you are looking for? I replaced x and y by cells A1 and B1 in this example.
Nov 12 2021 01:34 AM