Forum Discussion

Alain8's avatar
Alain8
Copper Contributor
Nov 07, 2021
Solved

fonction SI

Bonjour, comment peux-t-on éventuellement simplifier la fonction suivante : =SI(B4="";"";A4)+SI(C4="";"0";A4)+SI(D4="";"0";A4)+SI(E4="";"0";A4) et éventuellement l'étendre aux ligne 4 à 22 ? Merci...
excel
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Nov 07, 2021

Alain8 Started changing the original formula until I realized you asked for a simplification. Have a look at the attached file where I  used SUMPRODUCT. It should come out in French when you open the workbook.

Alain8's avatar
Alain8
Copper Contributor
Nov 07, 2021

Thank you very muchRiny_van_Eekelen , it is very nice.

Alain

    • Alain8's avatar
      Alain8
      Copper Contributor
      Nov 07, 2021
      Thank you Sergei, COUNTA doesn't work but NBVAL works very well. 👍
      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        Nov 08, 2021

        Alain8 

        That's why I attached the file to previous post. If open it shows correct formula for the current locale.

Resources