View original (French)

Conditional formula

Solved
Lili03630 Posted messages 48 Registration date   Status Member Last intervention   -  
danielc0 Posted messages 2175 Registration date   Status Member Last intervention   -

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

  1.
    danielc0 Posted messages 2175 Registration date   Status Member Last intervention   286
     

    So :

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

    Daniel

    1
  2. danielc0 Posted messages 2175 Registration date   Status Member Last intervention   286
     

    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

    0
    1. Lili03630 Posted messages 48 Registration date   Status Member Last intervention   1
       

      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.

      1