EXCEL FORMULA

Hi we need an expect with excel formulas to help us and create the formula we need on a column. Check attached worksheet - we need a formula to display the error message in column BB - we have added examples and explanation in column BC.

We need simple formula no VBA .

Please aks for clarifications if something is not clear - we will test before we release any money .