Need to determine if a call is Long Distance

[Paul D]

I have a Field "To Phone Number" and I need to tag it as
long distance.
Long Distance is defined if the phune number starts with a
1, but I do not want to also include toll free 800, 866,
877, 888 numbers

i.e. 13053458590 is long distance
5424355 is not long distance
18885420987 is not long distance
18005359876 is not long distnace

 

[Frank Kabel]

Hi
try
=IF(AND(LEFT(A1,1)="1",MID(A1,2,1)<>"8"),"long distance","")

 

[Trevor Shuttleworth]

paul

one way:

=IF(AND(LEFT(A1,1)="1",LEFT(A1,2)<>"18"),"long distance","not long
distance")

Regards

Trevor