Forum Discussion
Formule
I'm looking for what formula used for this:
c2 is a checkbox.
So if C2 is checked and that E4 is smaller than 12,000 the result must be 12,000 or if C2 is checked and cell E4 is greater than 12,000 the result must be the result of the formula E4 *, 149 * 5. If C2 is not checked the result is nothing. Tks
c2 is a checkbox.
So if C2 is checked and that E4 is smaller than 12,000 the result must be 12,000 or if C2 is checked and cell E4 is greater than 12,000 the result must be the result of the formula E4 *, 149 * 5. If C2 is not checked the result is nothing. Tks
5 Replies
- Dans le fond le E4*0,149*5 EST TOUT SIMPLEMENT UNE FORMULE POUR OBTENIR UN MONTANT.
Thanks, the formula was mangled by the automatic translation from French to English.
Try
=SI(C2;SI(E4<12000;12000;E4*0,149*5);"")
