P Pam2277 Apr 19, 2010 #1 I have my formula entered but need it to return a zero if the result is negative. Any help is greatly appreciated.
I have my formula entered but need it to return a zero if the result is negative. Any help is greatly appreciated.
P Pete_UK Apr 19, 2010 #2 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
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
