Concatenation doesn't work with array formulas although Laraunt Longre has a
free addin that offers functions that support it.

You want the
Morefunc.xll update 18/10/2005

on the English page.


If you just want a formula, it isn't too bad

If(sum(B1:B3)=0,"",if(B1=0,"",A1 & "=" & Text(B1,"$#,##0.00) & ", ") &
if(B2=0,"",A2&"="&Text(B2,"$#,##0.00)&", ") &
if(B3=0,"",A3&"="&Text(B2,"$#,##0.00)&", "))

Have to play with it to eliminate an ending comma.
--
Regards,
Tom Ogilvy




"b w" wrote in message
...
Thanks for the reply.

I'm trying to do this in-cell, but your solution indicates that I didn't
explain myself very well.

If B1 is zero, then your expression works, but I want to do this for ALL
B cells that are zero. An IF statement wouldn't be too practical if I
were looking at more than a few values of B.

As an example, If B1 and B2 and B3 are NOT zero, then my equation would
be =(A1 & B1) & (A2 & B2) & (A3 & B3).

But if B2 was Zero, then the equation would be:
=(A1 & B1) & (A3 & B3).

I was thinking that maybe an Array Formula would be the solution, but I
don't know, which is why I have posed the problem.

Thanks,
Bernie




*** Sent via Developersdex http://www.developersdex.com ***