# Excel formula

##### New Member
I am trying to create a formula that will sum two numbers on excel that will have an answer of the sum of the numbers except if the sum is less than zero the answer will be zero.

Help!

### Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

#### Elemental

##### Board Regular
=IF(SUM(A1:B1)>=1,SUM(A1:B1),0)

enjoy

#### Todd Bardoni

##### Well-known Member
if(a1+b1<0,0,a1+b1)

#### IML

##### MrExcel MVP
If your range is A1:A10, you could use
=MAX(0,SUM(A1:A10))

good luck

##### New Member
Thank you very much - one problem though: I really needed to have the difference of two numbers and if this difference is less than 0 it needs to be 0. For example: 25 - 35 = 0.

Thank you again!

#### Elemental

##### Board Regular
doesnt need to change much then

=IF(A1-B1>=0,A1-B1,0)

enjoy

Replies
7
Views
88
Replies
1
Views
90
Replies
6
Views
119
Replies
3
Views
148
Replies
1
Views
152

1,182,191
Messages
5,934,180
Members
436,935
Latest member
Fergjosh97

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back