Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 26th 08, 10:10 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2008
Posts: 2
Default 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 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-







  #2   Report Post  
Old March 26th 08, 10:25 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 1,311
Default 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   Report Post  
Old March 26th 08, 10:31 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 11,058
Default 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 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-






  #4   Report Post  
Old March 26th 08, 10:32 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2007
Posts: 11,501
Default 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 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-






  #5   Report Post  
Old March 26th 08, 10:32 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 5,942
Default 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 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-








  #6   Report Post  
Old March 26th 08, 10:35 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 3,942
Default 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 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-






  #7   Report Post  
Old March 26th 08, 10:48 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2008
Posts: 2
Default 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 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-






  #8   Report Post  
Old March 27th 08, 05:19 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 3,942
Default 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 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-








Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Writing IF Statement Angie Excel Worksheet Functions 4 June 5th 07 10:10 PM
Writing to csv Jeff Excel Discussion (Misc queries) 2 March 16th 07 02:35 PM
Complex Index Match Help (or at least complex to me) Jennifer Reitman Excel Discussion (Misc queries) 3 August 10th 06 08:51 PM
Equation Editor- problem when editing an equation Gaby L. Excel Discussion (Misc queries) 0 September 27th 05 09:24 PM
Help writing a formula Adam Excel Worksheet Functions 5 August 2nd 05 07:39 PM


All times are GMT +1. The time now is 06:23 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017