View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
eliano[_2_] eliano[_2_] is offline
external usenet poster
 
Posts: 79
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



Hi San,
a cell cannot contain himself or a reference to that cell
Regards