View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
travis[_3_] travis[_3_] is offline
external usenet poster
 
Posts: 58
Default Hide negative values!!!


San wrote:
I need help with hiding a negativ value!!!!

In cell A6 I have:

=A6-A4

But I just want to hide the value in A6 when it turns negative and not
change to whole value to 0

I have been reading other posts but nothing works.

=IF(A6 <0,0,A6)

excel just says that the formula contains an error! I don't put the
formula "=IF(A6 <0,0,A6)" in cell A6


If you just want to hide it, as opposed to eliminate it, you could
conditional format it to make the text colour the same as the
background colour. That will "hide" the negative value.

Your formula should work, as long as that formula isn't placed in A6
itself.

Alternatively you could use =max(0,A6)

Travis