Hey guys...i finally got it working. Since all of you helped, i'm trying to
make sure you all get credit for the assist.

Thanks again!

"Keith Faulconer" wrote:

Hey Steve,

I am not sure if this is what you are trying to do. Are the AEs and AFs
supposed to be cell references? If so, add in the row function as well.
Also, I don't know if this is just a copy/paste problem, the + should be &.
I copied/pasted your formula into my excel and got the name error. The AN
reference did not have a row reference, I didn't add a 1 to AN. After I did
that, it returned " - - - - - - - ". Here is a copy of the formula. Also,
one other note to make the formula easier, try doing,
=if(or(L8="Open",L8="Reopened").... then enter your criteria, you only have
to enter that big long line of text once. I copied an example of both.

Hope this helps.

=IF(L9="Open", (AE2&" - "&AF2&CHAR(10)&CHAR(10)&AG2&" -
"&AH2&CHAR(10)&CHAR(10)&AI2&" - "&AJ2&CHAR(10)&CHAR(10)&AK2&" -
"&AL2&CHAR(10)&CHAR(10)&AM2&" - "&AN2),IF(L9="Re-opened", (AE2&" -
"&AF2&CHAR(10)&CHAR(10)&AG2&" - "&AH2&CHAR(10)&CHAR(10)&AI2&" -
"&AJ2&CHAR(10)&CHAR(10)&AK2&" - "&AL2&CHAR(10)&CHAR(10)&AM2&" - "&AN2),""))

=IF(OR(L10="Open",L10="Re-opened"),(AE3&" -
"&AF3&CHAR(10)&CHAR(10)&AG3&" - "&AH3&CHAR(10)&CHAR(10)&AI3&" -
"&AJ3&CHAR(10)&CHAR(10)&AK3&" - "&AL3&CHAR(10)&CHAR(10)&AM3&" - "&AN3),"")




"Steve P" wrote in message
...
Hey everyone,

I'm writing a nested IF statement that will evaluate a particular cell in
a
given row and concatenate a series of other cells in that same row.
However,
I can't seem to get the formula to work...here's the code:

=IF(L8="Open", AE + " - " +AF + CHAR(10) + CHAR(10) AG + " - " +AH +
CHAR(10) + CHAR(10) AI + " - " +AJ + CHAR(10) + CHAR(10) AK + " - " +AL +
CHAR(10) + CHAR(10) AM + " - " +AN, IF(L8="Re-opened", AE + " - " +AF +
CHAR(10) + CHAR(10) AG + " - " +AH + CHAR(10) + CHAR(10) AI + " - " +AJ +
CHAR(10) + CHAR(10) AK + " - " +AL + CHAR(10) + CHAR(10) AM + " - " +AN,
""))


I keep getting a "name" error. What the code above is doing is first
checking for rows that are designated as "open". If the statement is
true,
its supposed to concatentate various other cells in the row and do an
alt+enter to separate some of the concatenations. When a row ISN'T
designated as "open", it reevaluates the original cell (L8) and then
checks
to see if the row has been designated as "Re-opened". It then performs
the
same concatenation.

What am I doing wrong here? Is this simply a syntax issue, or am I being
too ambitious concatenating? I'm really trying to save myself the hassle
of
manually copying and pasting all 150-200 records in this
spreadsheet...please
help!

~Steve P