View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
climate climate is offline
external usenet poster
 
Posts: 91
Default empty cells in calculation

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.