Sep 22 2022 09:40 AM
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="")
Sep 22 2022 12:34 PM
Solution
=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)")))
Sep 22 2022 12:34 PM
Solution
=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)")))