replace a negative result with a zero?
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
On Apr 19, 5:17*pm, Pam2277 wrote:
I have my formula entered but need it to return a zero if the result is
negative. *Any help is greatly appreciated.
--
Pam
|