I have tried all types of formula function for my assignment and this is the only one I don't understand what I am doing wrong. It is with my Case Problem 4 Athey Routing Slip for y Excel Spreadsheet. Here are all the formulas I have tried. Can someone help me to understand what I am doing wrong.

=IF(B16="Destroy",VLOOKUP(B14,Dept_Returns,2,FALSE),IF(B16="Return to Mfg",VLOOKUP(B14,Dept_Returns,3,FALSE),IF(B16="Repack"

=IF(Destroy,2,IF(Return to Mfg,3,IF(Repack,4,IF(Restock,5,FALSE))))

=IF('Destroy',2,IF('Return to Mfg',3,IF('Repack',4,IF('Restock',5,FALSE))))

=IF(0=Destroy,2,IF(B16=Return to Mfg,3,IF(B16=Repack,4,IF(B16=Restock,5,FALSE))))

=IF(0=#NAME?,2,IF(B16=Return to Mfg,3,IF(B16=Repack,4,IF(B16=Restock,5,FALSE))))

=(B16,IF(Destroy,2,IF(Return to Mfg,3,IF(Repack,4,IF(Restock,5,FALSE))))

=(B16="Destroy",2,IF(B16="Return to Mfg",3,IF(B16"Repack",4,IF(B16"Restock",5,FALSE))))

=IF(B16="Destroy","Return to Mfg","Repack","Restock",VLOOKUP(B14,Dept_Returns,2,3,4,5,FALSE),"None"))))

I'm ready to give up. I tried read and youtube site information that after 6 hours I will quit and take a hit on a low grade for this. I really can't figure this out.

\f