View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dpayne dpayne is offline
external usenet poster
 
Posts: 3
Default logical test and concatenate(string)

I am looking for a formula that will find non zeros in column A and string
columns A & B, where there are a least 50 rows of information. The stringed
cells should be seperated by "," and a space. I have the following formula
but it becomes to big to fit in the cell.

=if(a1<0,a1&" "&b1&","&" ","")&if(a2<0,a2&" "&b2&","&" ","")&if(a3....etc)

I appreciate the help