# How do i count a Negative number to 0

#### anniemalec

##### Board Regular
The answer to my formulae is -20% but i need any value below 0% to register as a value of 0%.... I can make it show 0% but when I do further calculations it still registers as the negative number...?????

Is there any way I can get around this..... I am doing an average of the answers and its using -20% but need it to use 0% not just show it?

### Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
if your value is in A1

then substitute

MAX(A1,0)

into all your formulas where A1 appears.

HTH

just use an if statement with your formula...

=if(formula>=0,formula,0)

Replies
6
Views
192
Replies
3
Views
512
Replies
5
Views
158
Replies
8
Views
220
Replies
8
Views
168

1,203,101
Messages
6,053,532
Members
444,670
Latest member
laurenmjones1111

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