View original (French)

Conditional formula

Lili03630 Posted messages 48 Registration date   Status Member Last intervention   -  
danielc0 Posted messages 2169 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

Answer 1 / 2
danielc0 Posted messages 2169 Registration date   Status Member Last intervention   283
 

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
Lili03630 Posted messages 48 Registration date   Status Member Last intervention  
 

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.

0
Answer 2 / 2
danielc0 Posted messages 2169 Registration date   Status Member Last intervention   283
 

So :

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

Daniel
0