Formula to find errors

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.

Hi randell.graybill,

Paste this formula in cell I2 and copy down:

Please Login or Register  to view this content.

Cheers,

I don't understand why I couldn't figure that out, so far it seems to work...I know I've had something very similar to that formula in the past and thought it worked at first glance but found flaws in the formula...maybe this is the same formula maybe its fine. Thanks for the help.

To mark your thread solved do the following: - Go to the first post - Click edit - Click Advance - Just below the word "Title:" you will see a dropdown with the word No prefix. - Change to Solve - Click Save