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