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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Try something like this:

=MAX(your_formula,0)

Does that help?

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

XL2002, WinXP-Pro
 
Back
Top