View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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