here is what the excel formula looks like:
thank you so much for your help
You would want to replace the nested if with a case statement.
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'
thank you so much. this worked perfectly