# return negative values as 0.00 in cells with existing formula

#### Noeler

##### New Member
Hi,
I have a cell with a simple calculation - =SUM((C42+0.01)-C44)

If the result from the formula is less than zero (i.e. a negative number) can i get this to be displayed in the cell as "0.00", but keep any positive numbers the same?

Thanks for any help!

### Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

#### Declamatory

##### Active Member
=if(sum((c42+0.01)-c44)<0,0,sum((c42+0.01)-c44))

##### MrExcel MVP
Generally like this...

=MAX(0,(C42+0.01)-C44)

Note. You don't SUM because SUM(number) >> number, i.e. SUM(2) >> 2.

Replies
3
Views
506
Replies
5
Views
299
Replies
3
Views
337
Replies
1
Views
1K
Replies
1
Views
337

1,190,916
Messages
5,983,572
Members
439,850
Latest member
suhailrocks786

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