Alternate way for nested if

[Ashhu]

I have sheet attached here, need output as per Column F.
The formula in Cell F should find specific text in B, C, D, E cells to get the output.
Conditions
if it finds all cells have "Fully Delivered" the overall status should be "Fully Delivered"
If it finds all cells have "Fully Delivered" and "Partial Delivery" the overall status should be "Partial Delivered"
If it finds all cells have "Fully Delivered" and "Partial Delivery" and "not Delivered" the overall status should be "Not Delivered"

Many thanks in advance.
Ashhu

 

[bosco_yip]

F2, copied down :

=INDEX({"Not Delivered";"Partial delivery";"Fully Delivered"},AGGREGATE(15,6,MATCH(B2:E2,{"Not Delivered";"Partial delivery";"Fully Delivered"},0),1))

Regards

 

[Ashhu]

View attachment 64988

F2, copied down :

=INDEX({"Not Delivered";"Partial delivery";"Fully Delivered"},AGGREGATE(15,6,MATCH(B2:E2,{"Not Delivered";"Partial delivery";"Fully Delivered"},0),1))

Regards

Thank you Bosco. Appreciate your quick response.