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
|