=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