Forum Discussion
MaKo3060
Jun 18, 2024Copper Contributor
Formula for finding product of factors.
I am looking for a formula to calculate the product of cells a1, b2 and c3. The formula should only calculate the cells with value greater than 0. If a cell is 0, it must not be included in the calculation.
7 Replies
Sort By
- Riny_van_EekelenPlatinum Contributor
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.
- MaKo3060Copper Contributor
- Riny_van_EekelenPlatinum Contributor
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 ""