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

    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.

  2. danielc0

    So :

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

    Daniel