Multiple IF

[ExcelRoy]

Hi All,

I am trying to add another IF to the following formula

IF AH16 is not "" then print "Partially Returned"
IF AF16 = AH16 then print "Returned"

=IF(AV16="","",IF(B16='Order Status'!AF16,"Received",IF(OR('Order Status'!AF16="",'Order Status'!AF16=0),"Ordered",IF('Order Status'!AF16<B16,"Partially Received"))))

Any help appreciated

 

[SpillerBD]

What order should the cells be evaluated in?