Determin a telehone number

[Guest]

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

 

[Guest]

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

for a telephone number in cell A1.

HTH

 

[Bob Phillips]

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

--
HTH

Bob Phillips

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

 

[Alan]

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

'Tel No' is the cell reference