empilage de formules

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