=IF(N20,REPT(J2,N2),IF(A2=B2,B2,""))

--
HTH

Bob Phillips

"KNS" wrote in message
...
I need to combine the text from multiple cells automatically based on
certain
conditions basically what I need would be something to the effect of
"If N20 print J2 "N2" times and if a2=b2 print b2" I hope that makes
sense
and someone can help me thanks. I'm using 2003.