Hi-
I have a quick question concerning matrices and null values.
On my worksheet, I am using a matrix to evaluate a series of formulas based on constant value inputs. There are times when 1 or 2 of the input values need to be zero. unfortunately when that happens, the matrix won't calculate due to some of the cells being a 'null value. is there a way to setup the matrix or data so that when a 'null value is present it won't fail?
i can send you the worksheet if it would be clearer.
thanks
steve