Excel 2007 : Help with IF and returning 1st character in a cell and returning text

I'm trying to write a formula that scans a cell and returns:

• "Foreclosure" if it contains an "H"
• "Performing" if the 1st character is 0
• "Subperforming" if the first character is 1 or 2
• "Non-performing" if the first character is 3 or greater

I have this so far (A1 Represents the 12 character cell to the left):
=IF(COUNTIF(A1,"*H*")=1,"Foreclosure",IF(LEFT(A1,1)=0,"Performing",IF(0<LEFT(A1,1)<=2,"Subperforming",IF(LEFT(A1,1)>2,"Non-Performing"))))
But it only returns "Non-performing" for every cell

This is an example of what I want it to do:
606000000000 --> Non-performing
HH0000000000 --> Foreclosure
000100000100 --> Performing
543333333333 --> Non-Performing
112222222333 --> Subperforming
11000000H000 --> Foreclosure
666666666666 --> Non-performing

Depends on order of importance... but

Please Login or Register  to view this content.

The other way I can think of is to write a custom function using VBA

Please Login or Register  to view this content.

Or this:

=IF(ISERROR(FIND("H",T(A1))>1)=FALSE, "Foreclosure",IF(LEFT(A1,1)= "0", "Performing",IF(VALUE(LEFT(A1,1))< 3,"Subperforming","Non-Performing")))