Copy data of two cells into one and change formula accordinaly

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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;
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
 
Back
Top