View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default 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