AnsweredAssumed Answered

Using two conditionals

Question asked by martinbacini on Nov 9, 2020
Latest reply on Nov 10, 2020 by martinbacini

Hello,I am using the following conditional

 

(First conditional)*

  • =iif(Min(Resultados(Compound_Name))/VD*100>Choose(1,Split(EspecificacionesPorcentaje,"-")) and Max(Resultados(Compound_Name))/VD*100<Choose(2,Split(EspecificacionesPorcentaje,"-")),"Cumple","No Cumple")

 

and,

(Second conditional)*

  • =iif(Min(Resultados(Compound_Name))>Choose(1,Split(Especificaciones,"-")) and Max(Resultados(Compound_Name))<Choose(2,Split(Especificaciones,"-")),"Cumple","No Cumple")

 

they separately work, but when I try to use them together and do

  • =iif(Especificaciones="n/a", (First conditional*),(Second conditional*))

 

it don´t work.
Thanks.

Outcomes