ok...i just realized how off my code was...no cell references! Here's the
revised code however i'm still getting errors

=IF(L42="Open", AE42 + " - " +AF42 + CHAR(10) + CHAR(10) AG42 + " - " +AH42
+ CHAR(10) + CHAR(10) AI42 + " - " +AJ42 + CHAR(10) + CHAR(10) AK42 + " - "
+AL42 + CHAR(10) + CHAR(10) AM42 + " - " +AN42, IF(L42="Re-opened", AE42 + "
- " +AF42 + CHAR(10) + CHAR(10) AG42 + " - " +AH42 + CHAR(10) + CHAR(10) AI42
+ " - " +AJ42 + CHAR(10) + CHAR(10) AK42 + " - " +AL42 + CHAR(10) + CHAR(10)
AM42 + " - " +AN42, ""))



"Steve P" wrote:

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