Formula to find errors

[randell.graybill]

I need a formula that will check a few things and if it finds an error the word error will appear in the cell, the details of which are in the attached spreadsheet. I have worked on this a great deal and cannot seem to make a formula with the proper logic. There is a sample of an error in the spreadsheet.