This one works well
=IF(OFFSET(D17;0;-1)<>0;C17*($L$6/$D$7)(V17+273,15)/($F$7+273,15);IF(OFFSET(D17;0;-2)<>0;B17($L$6/470)*(V17+273,15)/(850+273,15);IF(AND($H$7="V";$J$7="V";A17="GPFc_Essence");AD17;N17))
need some help with this nested if function somehow it doesn't accept any other options when i add two more conditions
=IF(OFFSET(D17;0;-1)<>0;C17*($L$6/$D$7)(V17+273,15)/($F$7+273,15);IF(OFFSET(D17;0;-2)<>0;B17($L$6/470)*(V17+273,15)/(850+273,15);IF(AND($H$7="V";$J$7="V";A17="GPFc_Essence");AD17;IF(AND($H$7="V";$J$7="N");AA17;IF(AND($H$7="N";$J$7="V";);AC17;N17)))))
returns either complete false N17 or value for $H$7="V";$J$7="V"; i want to add possible combinations can anyone suggest the best way to do so?
thank you in advance
Aucun commentaire:
Enregistrer un commentaire