Complicated IF statement?

That is exactly what I want but unfortunately I cannot manage to integrate it into my existing spreadsheet. For whatever reason I cannot make it work; I guess this is why I am an admin and not a developer (write code).

I have attached a section of the Bank spreadsheet I am working on.

Any help would be greatly appreciated.