hi jcavigli,

Please note that if one of the precedents of a1-3 is an error then this error is carried all the way through into all dependent cells ie if an error exists that's what you'll get - to overcome this you need to fix the initial error. See below for the Help files info about the "value" error...


Quote Originally Posted by Excel 2003 Help files:
Correct a #VALUE! error
Occurs when the wrong type of argument (argument: The values that a function uses to perform operations or calculations. The type of argument a function uses is specific to the function. Common arguments that are used within functions include numbers, text, cell references, and names.) or operand (operand: Items on either side of an operator in a formula. In Excel, operands can be values, cell references, names, labels, and functions.) is used.

Can you please attach an example file with your problem clearly shown & also the results that you would like to see?

hth
Rob