San wrote:
Yeah the format thing works.

With the formula it doesn't. I don't put the formula in the cell A6 I
put it in say A7 or anyother cell it still gives me the formula error

Could I make the negative values in cell A6 to zero. So instead of a
negative number I get zero, so I only calculate with positive numbers,

This is because I use the numbers for a graph and I don't want negative
values.

thx alot