replace a negative result with a zero?

[Pam2277]

I have my formula entered but need it to return a zero if the result is
negative. Any help is greatly appreciated.

 

[Pete_UK]

Well, what is the formula that you are using?

You could try this:

=MAX(your_formula,0)

to replace your_formula.

Hope this helps.

Pete

 

[Eduardo]

Hi,

=if(your formula<0,0,your formula)