When I generate a sheet with this function:
=IF(COUNTBLANK(G11:I11)=0;SUMPRODUCT(G11:I11;$G$10:$I$10)/SUM($G$10:$I$10);"")
(if there is at least one blank column, the result should show blank and no zero)
I get the #VALUE! result instead of the number calcuated. Editing the cell without changing anything gives the correct result.
I think it is an example of one of the remarks concerning the function parsing.
Koen.
Koen Pelsmaekers
Werkleider
Groep T Hogeschool Leuven
A. Vesaliusstraat 13
B-3000 Leuven
tel: +32 (0)16/301030 of +32 (0)16/301140
email: [EMAIL PROTECTED]
fax: +32 (0)16/301040
--- [This E-mail scanned for viruses by Declude Virus]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
