Thread: calculate formula if cell value is positive, show 0 if negative
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
KB KB is offline
external usenet poster
  
Posts: 41
Default calculate formula if cell value is positive, show 0 if negative
Im' sure this is simple, but i am stuck.
I need a formula to show a % value of an adjacent cell IF that cells value
is POSITIVE, and if that same cells value is NEGATIVE, to show 0.
I use Standard Edition 2003 w/SP3. Any suggestions greatly appreciated.
Thank You!
Reply With QuoteReply With Quote