empilage de formules

[BRISSAUD1]

bonjour,

je souhaiterai pouvoir empiler deux formules "=si et "

quel séparateur dois je mettre entre les deux formules pour que ces dernières soient prisent en compte?

Dans une même cellule.

ex : =SI(ET(A="2";B="3";C="4");0;9) ? SI(ET(A="5";B="3";C="3");11;0)

merci de vos retours 

didier

[#2]

Hi @BRISSAUD1,

Hi Didier,

To stack two "=IF" formulas in a single cell, you can use the following separator:

=IF(condition1, value1, IF(condition2, value2, value3))

In your example, the separator would be a comma:

=IF(ET(A="2", B="3", C="4"), 0, IF(ET(A="5", B="3", C="3"), 11, 0))

This formula will first evaluate the condition in the first "=IF" statement. If the condition is true, the value1 will be returned. Otherwise, the formula will evaluate the condition in the second "=IF" statement. If the second condition is true, the value2 will be returned. Otherwise, the value3 will be returned.

For example, if A="2", B="3", and C="4", the first "=IF" statement will return 0. The second "=IF" statement will not be evaluated because the first condition is true.

If A="5", B="3", and C="3", the first "=IF" statement will return 0. The second "=IF" statement will be evaluated, and the value2 will be returned, which is 11.

Here is other example:

=IF(condition1, value1, IF(condition2, value2, IF(condition3, value3, value4)))

Please click Mark as Best Response & Like if my post helped you to solve your issue.
This will help others to find the correct solution easily. It also closes the item.

If the post was useful in other ways, please consider giving it Like.

Kindest regards,

Leon Pavesic

[#3]

@BRISSAUD1 

Ces formules ne peuvent pas être combinées, du moins pas sous cette forme. Si la première condition n’est pas remplie, vous souhaitez renvoyer 9, mais ce n’est pas une valeur renvoyée par la deuxième formule.

Peut-être:

=SI(ET(A="2";B="3";C="4");0;SI(ET(A="5";B="3";C="3");11;0))

ou

=SI.CONDITIONS(ET(A="2";B="3";C="4");0;ET(A="5";B="3";C="3");11;VRAI;0)