ExcelBanter - IF Function

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - IF Function (https://www.excelbanter.com/excel-discussion-misc-queries/103685-if-function.html)

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

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

=<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)

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

wrote in message
ups.com...
I am trying to get this function correct and I am having a hard time!

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

=<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)