replace a negative result with a zero?
in [General]
|
Prev: 2007 excel autofilter back to 2003 autofilter?
Next: 2007 excel autofilter change back to 2003 autofilter?
From: Pam2277 on 19 Apr 2010 12:17 I have my formula entered but need it to return a zero if the result is negative. Any help is greatly appreciated. -- Pam
From: Pete_UK on 19 Apr 2010 12:22 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 <Pam2...(a)discussions.microsoft.com> wrote: > I have my formula entered but need it to return a zero if the result is > negative. Any help is greatly appreciated. > -- > Pam
From: Eduardo on 19 Apr 2010 12:33
Hi, =if(your formula<0,0,your formula) "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 |