View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tam25 tam25 is offline
external usenet poster
 
Posts: 10
Default exluding missing data values from equation

Mostly summing, some averaging, some reverse scoring (converting a response
from 5 to 1 or 1 to 5).


"T. Valko" wrote:

What kind of calculations?

Biff

"tam25" wrote in message
...
We are required to specify why data is missing and we have therefore given
it
a number value (eg 999 for missing, 777 for not applicable). However we
need
to be able to exclude these values from the final calculation in order to
get
the correct answer. What can we do???