Hi! I have a list where some cells have missing values (ie it says #MISSING
VALUE) in the cell (the list is linked to other lists). I want to be able to
calculate the average, mx, min etc for this list but it does not work since I
have the missing values. i want to convert them to 0. how can i do this? pls
help!