I need help writing a complex equation.

  • Thread starter Thread starter drummer07
  • Start date Start date
D

drummer07

I have three columns that I want to draw data from combine it into a single
line of data in another columns. So here’s the scenario.

Column 1 has an employee # there’s two designations 01XXXX and 02XXXX.
This is important. More on the importance of that later.

Column 2 has First name

Column 3 has Last name pretty simple.

So basically what I need to happen is, what I believe to be a simple
combination / complex if statement.

The Final column would look like this. (e-mail address removed)


That’s why 01xxxx and 02xxxx are so important 01 means alaskaair.com 02 mean
horizonair.com

Help!

-jeremy-
(e-mail address removed)
(e-mail address removed)
 
=B1&"."&C1&"@"&IF(A1="01XXXX","alaskaair.com","horizonair.com")

If you want the result to be a link:

=HYPERLINK(B1&"."&C1&"@"&IF(A1="01XXXX","alaskaair.com","horizonair.com"))

HTH,
Paul
 
In column D:
=HYPERLINK("mailto:" &
B1&"."&C1&"@"&IF(LEFT(A1,2)="01","alaskaair.com","horizonair.com"))
 
with the data laid out as described in A1, b1 & c1 try this in d1 and drag down

=B1&"."&C1&"@"&IF(LEFT(A1,2)="01","alaskaair","horizonair")

Mike
 
something like this should do with data in cells a2, b2 and c2...

=B2& "." & C2 & IF(LEFT(A2, 2) = "01", "@alaskaair.com", "@horizonair.com")
 
hi
play with this.....
=IF(LEFT(A2,2)="01",B2&C2&"@"&"alaskaair.com",B2&C2&"@"&"horizon.com")

regards
FSt1
 
YOU GUYS ROCK! THANKS! EVERYONE OF THOSE ANSWERS WORKED! WHAT A GREAT
COMMUNITY!
 
cool.
and you know what they say...
more than one way to skin a mamoth.

regards
FSt 1
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

automating use of complicated formula 4
Macro need to update the workbook 6
How can I sort data without affecting formula? 3
Conditional SUBTOTAL in XL210 Table 7
Conditional formatting quirk 8
External Data Warning Message - I have No External Data in wrkbk 0
Difference function and argument for two simple amounts 8
How do I match numeric coding in a worksheet to words in a pdf fil 5

Back
Top