ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   I need help writing a complex equation. (https://www.excelbanter.com/excel-discussion-misc-queries/181430-i-need-help-writing-complex-equation.html)

drummer07

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-







PCLIVE

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-









Gary''s Student

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-







Mike H

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-







Jim Thomlinson

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-







FSt1

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-







drummer07

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-







FSt1

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-








All times are GMT +1. The time now is 05:51 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com