SOLVED

Adicionar fórmula sem dar erro

Occasional Contributor

Temos:

=SE(J8="";"";SE(J8-$N$1<0;"vencido faz: "&(J8-$N$1)*-1&" dia(s)";SE(J8-$N$1=0;"vence hoje ";"vence em: "&J8-$N$1&" dia(s)")))

 

Temos que adicionar:

SE(L8="Cumprido";K8="")

1 Reply
best response confirmed by NathaliaCosta (Occasional Contributor)
Solution

@NathaliaCosta 

 

=SE(OU(J8="";L8="Cumprido");"";SE(J8-$N$1<0;"vencido faz: "&(J8-$N$1)*-1&" dia(s)";SE(J8-$N$1=0;"vence hoje ";"vence em: "&J8-$N$1&" dia(s)")))