How do i count a Negative number to 0

[anniemalec]

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?

 

[Weaver]

if your value is in A1

then substitute

MAX(A1,0)

into all your formulas where A1 appears.

HTH

 

[bryonwoods30]

just use an if statement with your formula...

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