Home |
Search |
Today's Posts |
#1
|
|||
|
|||
formula to combine cells using if/then
How about
=IF(OR(B1=D1,D1=""),A1&" & "&C1,A1&" "&B1&" and "&C1) "Linda G" wrote: Primary First Primay Last Secondary First Secondary Last First Last John Smith Debbie John & Debbie Carl Overstreet June Overstreet Carl & June Robert Johnson Susan Devers I have the formula that combines the primary first and primary last name if the Primary Last Name is either the same as the Secondary Last Name or the Secondary Last Name is blank. =IF(OR(B1=D1,D1=""),A1&" & "& C1,"") I need to add to this a formula that will combine the Primary First, Primary Last, & the Secondary First Name into the First Name Column when the Primary Last Name and the Secondary Last Name are not the same. |
#2
|
|||
|
|||
Thank You Roland, now I have one more question.
I have a formula that will put the Primary Last Name into Cell F2 and would like to (OR(B2=D2,D2="") I need to add the variable that if B2 Does not equal D2 and D2 is not blank that it will bring over D2 into cell F2. Thank YOU "Roland" wrote: How about =IF(OR(B1=D1,D1=""),A1&" & "&C1,A1&" "&B1&" and "&C1) "Linda G" wrote: Primary First Primay Last Secondary First Secondary Last First Last John Smith Debbie John & Debbie Carl Overstreet June Overstreet Carl & June Robert Johnson Susan Devers I have the formula that combines the primary first and primary last name if the Primary Last Name is either the same as the Secondary Last Name or the Secondary Last Name is blank. =IF(OR(B1=D1,D1=""),A1&" & "& C1,"") I need to add to this a formula that will combine the Primary First, Primary Last, & the Secondary First Name into the First Name Column when the Primary Last Name and the Secondary Last Name are not the same. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What formula is used for subtracting a range of different cells f. | Excel Worksheet Functions | |||
Cells displays formula, not results | Excel Worksheet Functions | |||
How do i select different cells to be use in a formula. | Excel Discussion (Misc queries) | |||
How do I set up a formula to repat 5 consecutive cells in a colum. | Excel Worksheet Functions | |||
Excel - formula to calculate colored fill cells within a range wi. | Excel Worksheet Functions |