View original (French)

Conditional formula

Solved
Lili03630 -  

Hello,

I can't express the following formula in Excel language for cell AF19: if cell O19 is empty, then 0; if cell O19 is less than or equal to 6.1, then 2.65; if cell O19 is greater than 6.1 and cell BT44 is checked, then cell AF19 should be equal to O19 x CG45, otherwise nothing.

Thank you to those who will take the time to respond.


2 answers

  • Votes
  • Date
  • Descending date
  1. danielc0

    So :

    =IF(BT46="x","",IF(O19="",0,IF(O19<=6,1,2.65,IF(BT44="x",O19*CG45,"")))))

    Daniel

    1. danielc0

      Hello,

      I translated "est cochée" as "is equal to x":

      =IF(O19="";0;IF(O19<=6,1;2.65;IF(BT44="x";O19*CG45;"")))

      Daniel

      1. Lili03630 Author

        Thank you Daniel, I was mistaken in my explanations but with my correction the formula works ;-)

        Yes, by checked it meant is equal to x.