Thread: IF Function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] bballmomsk@gmail.com is offline
external usenet poster
 
Posts: 2
Default 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)