Copy data of two cells into one and change formula accordinaly
 

I was given the following formula:
=C$5 & "@" & C$6 & " A, B, C"
However, I want it to be changed to the following formula:
=C$5 & "@" & C$6 & " A, B, C, D"
only when the data at the cell "C8" is equal to 1000 sec. and keep the
previous one when is 500 sec.

It is possible to do this?.

Thanks in advance.
Maperalia

Copy data of two cells into one and change formula accordinaly
 

See one answer in your previous thread...

In article ,
maperalia wrote:

I was given the following formula:
=C$5 & "@" & C$6 & " A, B, C"
However, I want it to be changed to the following formula:
=C$5 & "@" & C$6 & " A, B, C, D"
only when the data at the cell "C8" is equal to 1000 sec. and keep the
previous one when is 500 sec.

It is possible to do this?.

Thanks in advance.
Maperalia

Copy data of two cells into one and change formula accordinaly
 

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:

See one answer in your previous thread...

In article ,
maperalia wrote:

I was given the following formula:
=C$5 & "@" & C$6 & " A, B, C"
However, I want it to be changed to the following formula:
=C$5 & "@" & C$6 & " A, B, C, D"
only when the data at the cell "C8" is equal to 1000 sec. and keep the
previous one when is 500 sec.

It is possible to do this?.

Thanks in advance.
Maperalia

Copy data of two cells into one and change formula accordinaly
 

JE;
Do not worry. I found the problem anf fixed it. Basically, I forgot to add
the rest of the statement.
Thanks very much for your help.
Maperalia

"JE McGimpsey" wrote:

See one answer in your previous thread...

In article ,
maperalia wrote:

I was given the following formula:
=C$5 & "@" & C$6 & " A, B, C"
However, I want it to be changed to the following formula:
=C$5 & "@" & C$6 & " A, B, C, D"
only when the data at the cell "C8" is equal to 1000 sec. and keep the
previous one when is 500 sec.

It is possible to do this?.

Thanks in advance.
Maperalia