"climate" wrote in message
...
I have a large matrix which many of that cells are empty or blank,when i
subtract
empty cells from a reference value for example B1000= 5, empty cells act
as
zero"0", resulting value = - 5, i don't want this. would you please help
me.
best regards.

I do not understand your question. If you subtract 0 from 5 you get 5,
not -5.
Are you (by any chance) subtracting the reference value from the total of
the cells?
If you're still having trouble understanding this, try the same thing with a
small matrix, say 2x2 or 3x3. State clearly what is in each cell, quote the
formula you are using, say what result you get and what you expect.