Hi pete
Thank's, it works correctly.
regards

"Pete_UK" wrote:

You could use the ABS function if you want the result to be positive,
or to avoid the calculation you can have something like:

=IF(A1="","",A1-B1)

Hope this helps.

Pete

On Dec 10, 8:28 am, climate wrote:
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.