Need help. Add more condition into formular

Stacy Teh

Hi experts, seeking for advice.

Currently, I did a formular to do as below:

if problematic = No, Dropship = No, transition duration <2, it will be on time, or else, missed.

if problematic = No, Dropship = Yes, transition duration <4, it will be on time, or else, missed.

I am trying to add:

if problematic = Yes. no matter what is other condition, the answer need to be ontime.

I am trying to build the formular. But i am stuck. Seek for advice.

Thank you.

Vinoth

Hi @Stacy Teh, Please try the below formula and let me know if it works for you.

=IF(Problematic@row = "Yes", "Ontime", IF(Dropship@row = "No", IF([Transaction duration]@row < 2, "Ontime", "Missed"), IF(Dropship@row = "Yes", IF([Transaction duration]@row < 4, "Ontime", "Missed"))))

Vinoth

Hi @Stacy Teh, Please try the below formula and let me know if it works for you.

=IF(Problematic@row = "Yes", "Ontime", IF(Dropship@row = "No", IF([Transaction duration]@row < 2, "Ontime", "Missed"), IF(Dropship@row = "Yes", IF([Transaction duration]@row < 4, "Ontime", "Missed"))))

Stacy Teh

Hi Vinoth,

thank you so much. The formular works!

thank you for your advice!

Have a nice day.