zero if credit

New Contributor

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

3 Replies

@1vanessamo 

=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.

 

YES, THAT WORKS . THANK YOU

@1vanessamo As a variant:

=MIN(0,A1+B1)

where A1+B1 represent your x+y