Can I combine the text from multiple cells automatically

K

KNS

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 N2>0 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.
 
K

KNS

This was great, the only problem is that the second part of the function
IF(A2=B2,B2,"")) isn't working. Any help would be great.

=IF(N2>0,REPT(J2,N2),IF(A2=B2,B2,""))

:
 
B

Bob Phillips

How do you mean not working? Does it never happen, or give the wrong result?
I must admit I wasn't clear as to what you wanted there, so I interpreted it
as

IF N2>0 return J2 N2 times
Else If A2=B2 return B2
Else return nothing
 
K

KNS

Sorry, I need it to perform both if that's possible, so

IF N2>0 return J2 N2 times
And If A2=B2 return B2
Else return nothing
 
Top