IF Function

B

bballmomsk

I am trying to get this function correct and I am having a hard time!

If the 1st 5 characters (NUMBERS Formatted as Text) are:

=<10089 (1008901056874659871324) the result should read "Centerpoint
Energy"

=<10443 (10443720004597894) the result should read "TXU Electric
Delivery

=<10032 (110327894565765168)-> AEP Central (CPL)

=<10204 (1020404976546415646) -> AEP North (WTU)

=<10400 (104005119841657941654) -> Texas - New Mexico Power

1008901 Centerpoint (CNP)
1044372000 TXU Electric Delivery (TXUED)
100327894 AEP Central (CPL)
102040497 AEP North (WTU)
104005 Texas-New Mexico Power (TNMP)
 
B

Biff

Hi!

What if the first 5 are 10030. That's "=<" compared to all of the criteria
so which one should it be? It's "=<" 10089 so should it be CNP? It's "=<"
10443 so should it be TXUED? See where I'm goin' with this?

Biff
 
Top