Formula and Condition for a Calculation to leave a zero if the res

[SSG Devine]

I need to generate a formual with a condition condition that if the formula
returns a negative number the resulting answer should be zero? Can anyone
help

 

[Beege]

SSG

=IF(your formula<0,0,your formula)
Beege

 

[bpeltzer]

Where you currently have =formula, use =if((formula)<0,0,formula)

 

[Ron Coderre]

Try something like this:

=MAX(your_formula,0)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro