To Many "OR" Expressions in Formula Tool?

Question

Is there a such thing as using to many "OR" expressions in a formula while using the Formula Tool. I was typing out the formula and everything appeared fine but after awhile... the formula turned black.

Here's the example:

IF [Assets (Y/N)] OR [Liabilities (Y/N)] OR [Revenues (Y/N)] OR [CFO Tier 1 - Reg. Oversight] OR [CFO Tier 1 - Ext. Reporting] OR [CFO Tier 1 - Liq, Fund, Cap Signif]= "Y" THEN "1" ELSE "" ENDIF

kelsey_kincaid · Answer

Hi @lisamccullough

Try this:

IF [Assets (Y/N)]="Y" OR [Liabilities (Y/N)] ="Y" OR [Revenues (Y/N)]="Y" OR [CFO Tier 1 - Reg. Oversight]="Y" OR [CFO Tier 1 - Ext. Reporting] ="Y" OR [CFO Tier 1 - Liq, Fund, Cap Signif]= "Y" THEN "1" ELSE "" ENDIF

philipmannering · Answer

Turned black? This shouldn't happen in your expression. I assume the first 5 fields are of type Boolean?