Copy data of two cells into one
 

=C5 & "@" & C6 & " a,b,c"

--
Gary''s Student - gsnu200727

Copy data of two cells into one
 

Thank you Gary. It is exactly what I need.

Maperalia
"Gary''s Student" wrote:

=C5 & "@" & C6 & " a,b,c"

--
Gary''s Student - gsnu200727

Copy data of two cells into one
 

Gary;
I have the formula you gave me (=C5 & "@" & C6 & " a,b,c")
placed on the cell "C20". It is working perfectly, however, I need to add
the following information:
When the cell "C8" has the value 1000 I want the formula in the cell "C20"
to be =C5 & "@" & C6 & " a,b,c,d" instead.
It is possible to do this.

Thanks in advance.
Maperalia

"Gary''s Student" wrote:

=C5 & "@" & C6 & " a,b,c"

--
Gary''s Student - gsnu200727

Copy data of two cells into one
 

Use
=IF(c8=2000,C5 & "@" & C6 & " a,b,c,d",C5 & "@" & C6 & " a,b,c")

maperalia wrote:
Gary;
I have the formula you gave me (=C5 & "@" & C6 & " a,b,c")
placed on the cell "C20". It is working perfectly, however, I need to add
the following information:
When the cell "C8" has the value 1000 I want the formula in the cell "C20"
to be =C5 & "@" & C6 & " a,b,c,d" instead.
It is possible to do this.

Thanks in advance.
Maperalia

"Gary''s Student" wrote:


=C5 & "@" & C6 & " a,b,c"

--
Gary''s Student - gsnu200727

Copy data of two cells into one
 

One way:

=C5 & "@" & C6 & " a,b,c" & IF(C8=1000,",d","")

In article ,
maperalia wrote:

Gary;
I have the formula you gave me (=C5 & "@" & C6 & " a,b,c")
placed on the cell "C20". It is working perfectly, however, I need to add
the following information:
When the cell "C8" has the value 1000 I want the formula in the cell "C20"
to be =C5 & "@" & C6 & " a,b,c,d" instead.
It is possible to do this.

Thanks in advance.
Maperalia

"Gary''s Student" wrote:

=C5 & "@" & C6 & " a,b,c"

--
Gary''s Student - gsnu200727

Copy data of two cells into one
 

JE;
Thanks very much. Works perfectly!!!!

Maperalia

"JE McGimpsey" wrote:

One way:

=C5 & "@" & C6 & " a,b,c" & IF(C8=1000,",d","")

In article ,
maperalia wrote:

Gary;
I have the formula you gave me (=C5 & "@" & C6 & " a,b,c")
placed on the cell "C20". It is working perfectly, however, I need to add
the following information:
When the cell "C8" has the value 1000 I want the formula in the cell "C20"
to be =C5 & "@" & C6 & " a,b,c,d" instead.
It is possible to do this.

Thanks in advance.
Maperalia

"Gary''s Student" wrote:

=C5 & "@" & C6 & " a,b,c"

--
Gary''s Student - gsnu200727

Copy data of two cells into one
 

Bob;
Thanks very much. Works perfectly!!!!

Maperalia

"Bob I" wrote:

Use
=IF(c8=2000,C5 & "@" & C6 & " a,b,c,d",C5 & "@" & C6 & " a,b,c")

maperalia wrote:
Gary;
I have the formula you gave me (=C5 & "@" & C6 & " a,b,c")
placed on the cell "C20". It is working perfectly, however, I need to add
the following information:
When the cell "C8" has the value 1000 I want the formula in the cell "C20"
to be =C5 & "@" & C6 & " a,b,c,d" instead.
It is possible to do this.

Thanks in advance.
Maperalia

"Gary''s Student" wrote:


=C5 & "@" & C6 & " a,b,c"

--
Gary''s Student - gsnu200727

Copy data of two cells into one
 

JE;
The previous formula (=C5 & "@" & C6 & " a,b,c") was reprensented in vba as
a the following statement: "=R5C & ""@"" & R6C & "" a, b, c""".
I wondert if you can help me to represent your formula (=C$5 & "@" & C$6 & "
a,b,c" & IF(C$8="0.0025 in/min",",d","")) in vba' statement.
The problem is that I have a macro which clean the cells to type the new
data. Since this is a formula I have you place the formula again.

Thanks in advance.
Maperalia




"JE McGimpsey" wrote:

One way:

=C5 & "@" & C6 & " a,b,c" & IF(C8=1000,",d","")

In article ,
maperalia wrote:

Gary;
I have the formula you gave me (=C5 & "@" & C6 & " a,b,c")
placed on the cell "C20". It is working perfectly, however, I need to add
the following information:
When the cell "C8" has the value 1000 I want the formula in the cell "C20"
to be =C5 & "@" & C6 & " a,b,c,d" instead.
It is possible to do this.

Thanks in advance.
Maperalia

"Gary''s Student" wrote:

=C5 & "@" & C6 & " a,b,c"

--
Gary''s Student - gsnu200727

Copy data of two cells into one
 

One way:

"=R5C & ""@"" & R6C & ""a, b, c"" & IF(R8C=""0.0025
in/min"","",d"","""")"



In article ,
maperalia wrote:

The previous formula (=C5 & "@" & C6 & " a,b,c") was reprensented in vba as
a the following statement: "=R5C & ""@"" & R6C & "" a, b, c""".
I wondert if you can help me to represent your formula (=C$5 & "@" & C$6 & "
a,b,c" & IF(C$8="0.0025 in/min",",d","")) in vba' statement.
The problem is that I have a macro which clean the cells to type the new
data. Since this is a formula I have you place the formula again.

Copy data of two cells into one
 

JE;
Thanks for your quick response.
I put the statament you gave me ( "=R5C & ""@"" & R6C & ""a, b, c"" &
IF(R8C=""0.0025 in/min"","",d"","""")" ) and I got the following error
message:
"Compile Error: Expected:line number or label or statement or end of
statement"
Could you please tell me how to fix it?

Thanks.
Maperalia


"JE McGimpsey" wrote:

One way:

"=R5C & ""@"" & R6C & ""a, b, c"" & IF(R8C=""0.0025
in/min"","",d"","""")"



In article ,
maperalia wrote:

The previous formula (=C5 & "@" & C6 & " a,b,c") was reprensented in vba as
a the following statement: "=R5C & ""@"" & R6C & "" a, b, c""".
I wondert if you can help me to represent your formula (=C$5 & "@" & C$6 & "
a,b,c" & IF(C$8="0.0025 in/min",",d","")) in vba' statement.
The problem is that I have a macro which clean the cells to type the new
data. Since this is a formula I have you place the formula again.