Yes, you've got your syntax seriously wrong.
Concatenation uses the symbol &, not + which you've sometimes used and
sometimes omitted.
If you want to include the text AF, you need to enclose it in quote marks
"AF"; if instead of that you intended to include the content of a cell, you
need to give the reference of the cell, not just the row identifier, so
perhaps you intended somnething like AF8, rather than AF?
--
David Biddulph

"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