Is there a better way to perform this function?

[mshane]

I have several ranges of extensions and need to create the full number for hundreds of entries in a spreadsheet. For example extensions between 2225 and 2324 = 267-ext while 3700 thru 3799 = 302-ext.

Here is my list of extensions and full number to join to it:
2225 - 2324 = (409) 267-ext
3700 - 3799 = (409) 302-ext
3800 - 3999 = (409) 900-ext

I want to be able to put in the extension and have the next field create the full number.

Is there a better function to do this than the one listed below?
IF((AND(G392>=2225,G392<=2324)),"(409) 267-"&G392,IF((AND(G392>=3700,G392<=3799)),"(409) 302-"&G392,IF((AND(G392>=3800,G392<=3999)),"(409) 900-"&G392

Thanks ahead of time.

[NBVC]

Another way could be to create yourself a little lookup table.

e.g.

Please Login or Register  to view this content.

These show the bottom ranges and the corresponding extension

Then use a formula

=LOOKUP(G392,$J$1:$K$3)&"-"&G392

where J1:K3 contains the lookup table above

Edit: Made table range absolute so that it won't change if formula copied down.