View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michael McClellan Michael McClellan is offline
external usenet poster
 
Posts: 15
Default function to return positive number or zero



OK Gurus, here is a good one.

I need a function in excel that will return a number if the number in
question is positive, but if the number is negative will return zero.
Is there a function like this?

I need to put this into a formula, so no macros please.

Thanks.

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!