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

Reply
White Belt

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

View solution in original post


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

View solution in original post

Highlighted
White Belt

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

thank you so much. this worked perfectly

Announcements
Check out these great solution videos! The new iSolveditWithDomoboard is live, share yours and earn higher rankings in Dojo click here!