Forum Discussion

MaKo3060's avatar
MaKo3060
Copper Contributor
Jun 18, 2024

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

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum 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.

     

      • Riny_van_Eekelen's avatar
        Riny_van_Eekelen
        Platinum Contributor

        MaKo3060 

        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 ""

         

Resources