On Mon, 21 Jun 2004 08:28:23 -0700, Phil Hageman
wrote:

Formula:
=(SUM(PRODUCT(X17,X19),PRODUCT(X20,X22),PRODUCT(X 23,X25)))*G26

Given:
X17 = 0, X19 = .33
X20 = blank (the result of a formula returning “”), X22 = .33
X23 = blank (the result of a formula returning “”), X25 = .34
G26 = .25

What is happening: 1.) The first PRODUCT multiplies x17 (0) times X19 (.33), which equals zero. 2.) In the second PRODUCT calculation, X20 becomes .25, which is multiplied by .33, which equals .0825, and 2.) In the third PRODUCT calculation, X23 becomes .25, which is multiplied by .34, which equals .0850. The three products are summed to .1675. Why does X20 and X23 become .25?

If I enter a zero value for X22 and X25, the formula returns zeros in the second and third portion of the formula.

What is the modification of this formula to return a zero, without making X22 and X25 zero - the formula accepts the blank returned by another formula as a zero?

Thanks,
Phil

PRODUCT is ignoring non-numeric entries.

From HELP:

If an argument is an array or reference, only numbers in the array or reference
are counted. Empty cells, logical values, text, or error values in the array or
reference are ignored.



--ron