You're welcome - thanks for feeding back.

Pete

On Dec 10, 10:26 am, climate
wrote:
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.- Hide quoted text -

- Show quoted text -