This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

IFS AND HELP

Posted on 11-18-2023 09:26 PM
samolorz
Bronze 3
Bronze 3
Reply posted on --/--/---- --:-- AM

Hello friends, could you help me? How can I use the following for a column? 

IFS(AND(ISNOTBLANK([SE REPORTA]),ISBLANK([INICIO DE CARGA]), ISBLANK([FIN DE CARGA])),

"ESPERA",AND(ISNOTBLANK([INICIO DE CARGA]), ISNOTBLANK([SE REPORTA]), ISBLANK([FIN DE CARGA])),"CARGANDO",AND(ISNOTBLANK([SE REPORTA]),ISNOTBLANK([INICIO DE CARGA]), ISNOTBLANK([FIN DE CARGA])),

"TRANSITO",AND(ISNOTBLANK([FECHA DE ARRIBO]),ISBLANK([FECHA DE DESCARGA]), ISBLANK([FECHA DE LIBERACION])),

"PENDIENTE",AND(ISNOTBLANK([FECHA DE ARRIBO]), ISNOTBLANK([FECHA DE DESCARGA]), ISBLANK([FECHA DE LIBERACION])),"PROCESO",AND(ISNOTBLANK([FECHA DE ARRIBO]),ISNOTBLANK([FECHA DE DESCARGA]), ISNOTBLANK([FECHA DE LIBERACION])),

"LIBERADA")

 

 

 

Muchas gracias 

0 0 47
Topic Labels
0 Likes
0 REPLIES 0
Top Labels in this Space