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
0
Best 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

Chris0
Answers

thank you so much. this worked perfectly
1