IF Function
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)
|