Can i write a nested "if" "and" statement in beast mode?

pprice11 Member

June 2019 in Magic ETL

here is what the excel formula looks like:

 

=IF(AND(K5=0,L5=0),"remaining",IF(AND(K5=0,L5>0),"resolved",IF(AND(K5>0,L5>0),"no gap","new")))

 

thank you so much for your help

0

Best Answer

• 

  cwolman Contributor

  June 2019 Answer ✓

  You would want to replace the nested if with a case statement.

   

  case 

    when K5=0 and L5=0 then 'remaining'

    when K5=0 and L5>0 then 'resolved'

    when K5>0 and L5>0 then 'no gap'

    else 'new'

  end

   

  
  -----------------
  Chris

  0

Answers

• 

  cwolman Contributor

  June 2019 Answer ✓

  You would want to replace the nested if with a case statement.

   

  case 

    when K5=0 and L5=0 then 'remaining'

    when K5=0 and L5>0 then 'resolved'

    when K5>0 and L5>0 then 'no gap'

    else 'new'

  end

   

  
  -----------------
  Chris

  0
• 

  pprice11 Member

  June 2019

  thank you so much. this worked perfectly

  1