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

Reply
Visitor

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

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


Accepted Solutions
Major Blue Belt

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

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

All Replies
Major Blue Belt

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

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
Highlighted
Visitor

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

thank you so much. this worked perfectly

Announcements
Looking for the latest Community solutions? Please visit our accepted solutions board here!