"San" wrote in message
ps.com...
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


thx for your help!

As already explained by the previous posters, your formula contains a
circular reference. Won't work.
Actually you don't need a formula at all:
Just change the number format of your cells to a custom format. You will
have to define a new custom format:
#;;0

(the '#' leaves all positive numbers untouched. After the semicolon you
define how negative numbers should be formatted, Since you don't want them
to show at all, just don't define anything. After the next semicolon, you
define what to show in case of zero.

That's all.

Cheers,

Joerg