View Single Post
  #1   Report Post  
djjny
 
Posts: n/a
Default how do you make negative numbers show up as 0 in Excel?

I want to force a formula I have to show up as a zero if the value is less
than zero. I have tried embedding something in the formula to do this, but
it will not work. anyone have any suggestions? Is there a way to format a
field to display zero when the value is less than zero? I am using Excel
2000.