Determin a telehone number
 

I want to determin a telephone number.
I know that if a telephone number ends in a one (1) then it comes from a
certain type of service, so what I need is a formular that says
if (Tel No) does not end in 1 then Highway otherwise ISDN
I can then copy this formular to the other numbers in the range

Determin a telehone number
 

=IF(RIGHT(A1,1)="1","ISDN","Highway")

for a telephone number in cell A1.

HTH
--
Allllen


"Sean" wrote:

I want to determin a telephone number.
I know that if a telephone number ends in a one (1) then it comes from a
certain type of service, so what I need is a formular that says
if (Tel No) does not end in 1 then Highway otherwise ISDN
I can then copy this formular to the other numbers in the range

Determin a telehone number
 

=IF(RIGHT(A1,1)="1","ISDN","Highway")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Sean" wrote in message
...
I want to determin a telephone number.
I know that if a telephone number ends in a one (1) then it comes from a
certain type of service, so what I need is a formular that says
if (Tel No) does not end in 1 then Highway otherwise ISDN
I can then copy this formular to the other numbers in the range

Determin a telehone number
 

=If(Right('Tel No',1)="1","ISDN","Highway")

'Tel No' is the cell reference

Sean wrote:
I want to determin a telephone number.
I know that if a telephone number ends in a one (1) then it comes from a
certain type of service, so what I need is a formular that says
if (Tel No) does not end in 1 then Highway otherwise ISDN
I can then copy this formular to the other numbers in the range