SOLVED

fonction SI

Copper Contributor

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

5 Replies

Re: fonction SI

@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.

Re: fonction SI

Thank you very much@Riny_van_Eekelen , it is very nice.

Alain

best response confirmed by Alain8 (Copper Contributor)
Solution

Re: fonction SI

As variant

``=A4*COUNTA(B4:E4)``

Re: fonction SI

Thank you Sergei, COUNTA doesn't work but NBVAL works very well. :thumbs_up:

Re: fonction SI

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

1 best response

Accepted Solutions
best response confirmed by Alain8 (Copper Contributor)
Solution

Re: fonction SI

As variant

``=A4*COUNTA(B4:E4)``