Forum Discussion
Formula for finding product of factors.
MaKo3060 The cells are on a diagonal of a 3x3 matrix, Assuming all other cells are empty, you could try this:
If this doesn't work for you, please clarify and show us how your data is set-up.
Well, that is totally different set-up compared to what you described, but it should work the same.
Or perhaps you should change whatever formula you have to calculate the factors. If the result is zero, return the number 1 or an empty string ""
The preceding was a principled example. In reality, the situation is this:
Factors A, B, and C are calculated individually with separate formulas; the result for a random factor can be 0. Everything takes place on the same row.
If a factor has the value 0, the product will also be 0; therefore, only factors greater than 0 must be included in the calculation of the product.MaKo3060 My goodness! Why didn't you give a realistic example from the start?
Try this then:
=PRODUCT(IF(D3>0,D3,1),IF(H3>0,H3,1),IF(L3>0,L3,1))