Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need help writing a complex equation.
I have three columns that I want to draw data from combine it into a single
line of data in another columns. So heres the scenario. Column 1 has an employee # theres 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. Thats why 01xxxx and 02xxxx are so important 01 means alaskaair.com 02 mean horizonair.com Help! -jeremy- |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need help writing a complex equation.
","hor izonair.com") If you want the result to be a link: =HYPERLINK(B1&"."&C1&"@"&IF(A1="01XXXX","alaskaair .com","horizonair.com")) HTH, Paul -- "drummer07" wrote in message ... 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. That's why 01xxxx and 02xxxx are so important 01 means alaskaair.com 02 mean horizonair.com Help! -jeremy- |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need help writing a complex equation.
In column D:
=HYPERLINK("mailto:" & "," horizonair.com")) -- Gary''s Student - gsnu200775 "drummer07" wrote: I have three columns that I want to draw data from combine it into a single line of data in another columns. So heres the scenario. Column 1 has an employee # theres 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. Thats why 01xxxx and 02xxxx are so important 01 means alaskaair.com 02 mean horizonair.com Help! -jeremy- |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need help writing a complex equation.
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","hor izonair") Mike "drummer07" wrote: I have three columns that I want to draw data from combine it into a single line of data in another columns. So heres the scenario. Column 1 has an employee # theres 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. Thats why 01xxxx and 02xxxx are so important 01 means alaskaair.com 02 mean horizonair.com Help! -jeremy- |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need help writing a complex equation.
something like this should do with data in cells a2, b2 and c2...
=B2& "." & C2 & IF(LEFT(A2, 2) = "01", ", ") -- HTH... Jim Thomlinson "drummer07" wrote: I have three columns that I want to draw data from combine it into a single line of data in another columns. So heres the scenario. Column 1 has an employee # theres 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. Thats why 01xxxx and 02xxxx are so important 01 means alaskaair.com 02 mean horizonair.com Help! -jeremy- |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need help writing a complex equation.
hi
play with this..... ",B2&C ") regards FSt1 "drummer07" wrote: I have three columns that I want to draw data from combine it into a single line of data in another columns. So heres the scenario. Column 1 has an employee # theres 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. Thats why 01xxxx and 02xxxx are so important 01 means alaskaair.com 02 mean horizonair.com Help! -jeremy- |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need help writing a complex equation.
YOU GUYS ROCK! THANKS! EVERYONE OF THOSE ANSWERS WORKED! WHAT A GREAT
COMMUNITY! "FSt1" wrote: hi play with this..... ",B2&C ") regards FSt1 "drummer07" wrote: I have three columns that I want to draw data from combine it into a single line of data in another columns. So heres the scenario. Column 1 has an employee # theres 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. Thats why 01xxxx and 02xxxx are so important 01 means alaskaair.com 02 mean horizonair.com Help! -jeremy- |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need help writing a complex equation.
cool.
and you know what they say... more than one way to skin a mamoth. regards FSt 1 "drummer07" wrote: YOU GUYS ROCK! THANKS! EVERYONE OF THOSE ANSWERS WORKED! WHAT A GREAT COMMUNITY! "FSt1" wrote: hi play with this..... ",B2&C ") regards FSt1 "drummer07" wrote: I have three columns that I want to draw data from combine it into a single line of data in another columns. So heres the scenario. Column 1 has an employee # theres 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. Thats why 01xxxx and 02xxxx are so important 01 means alaskaair.com 02 mean horizonair.com Help! -jeremy- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Writing IF Statement | Excel Worksheet Functions | |||
Writing to csv | Excel Discussion (Misc queries) | |||
Complex Index Match Help (or at least complex to me) | Excel Discussion (Misc queries) | |||
Equation Editor- problem when editing an equation | Excel Discussion (Misc queries) | |||
Help writing a formula | Excel Worksheet Functions |