

- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
I wish I could write formulas with line breaks so that it’s easier to read, comprehend, and modify. For instance, I wish the first formula could be written like the second. It currently returns an error.
Current:
IF(FIND( “engineer”,LOWER( {Collateral Title})) > 0, “Engineer”,IF(FIND( “engineer”,LOWER( {Overview / Short-form content} )) > 0,“Engineer”,IF(FIND( “engineer”,LOWER( {Preloaded Topic} )) > 0,“Engineer”,IF(FIND( “coding”,LOWER( {Collateral Title} )) > 0,“Engineer”,IF(FIND( “coding”,LOWER( {Overview / Short-form content} )) > 0,“Engineer”,IF(FIND( “coding”,LOWER( {Preloaded Topic} ))>0,“Engineer”, IF(FIND( “developer”,LOWER( {Collateral Title})) > 0,“Engineer”,IF(FIND( “developer”,LOWER( {Overview / Short-form content} )) > 0,“Engineer”,IF(FIND( “developer”,LOWER( {Preloaded Topic} )) >0,“Engineer”,"")))))))))
Desired:
IF(FIND( “engineer”,
LOWER( {Collateral Title})) > 0,
“Engineer”,
IF(FIND( “engineer”,
LOWER( {Overview / Short-form content} )) > 0,
“Engineer”,
IF(FIND( “engineer”,
LOWER( {Preloaded Topic} )) > 0,
“Engineer”,
IF(FIND( “coding”,
LOWER( {Collateral Title} )) > 0,
“Engineer”,
IF(FIND( “coding” ,
LOWER( {Overview / Short-form content} )) > 0,
“Engineer”,
IF(FIND( “coding”,
LOWER( {Preloaded Topic} ))>0,
“Engineer”,
IF(FIND( “developer”,
LOWER( {Collateral Title})) > 0,
“Engineer”,
IF(FIND( “developer”,
LOWER( {Overview / Short-form content} )) > 0,
“Engineer”,
IF(FIND( “developer”,
LOWER( {Preloaded Topic} )) >0,
“Engineer”,
“”)))))))))