IF Function

  • Thread starter Thread starter bballmomsk
  • Start date Start date
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)
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF Function 1
OT| The Decline and Fall of the American Empire: Four Scenarios for the End of the American Century 0
Public Preview Program Email Received 9
how do I make a 10 minute presentation out of 5 pages? 8
Hilarious! Can Nikon come up with something like this? 5
Problems Loading Large String Array into Array variable 6
Windows 10 Windows 10 Fall Creators Update 15
Living With a Computer 3

Back
Top