Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

How can I build a longer (7>)calculated formula using the =IF function

  Asked By: Caleb    Date: Feb 27    Category: Sharepoint    Views: 2227

I'm trying to create a calculated column containing more than 7
nested "IF functions". How can I create a more elaborate formula which
exceeds that limit?



3 Answers Found

Answer #1    Answered By: Elisha Abbott     Answered On: Feb 27

The only way is to create  multiple calc. columns, each of them
with a max of 7 nested IF statements and then combine them in another
calc. column.

Answer #2    Answered By: Naimish Ranganekar     Answered On: Feb 27

What formula  would I need to use to combine those columns together into a final column?

Answer #3    Answered By: Caleb Gordon     Answered On: Feb 27

Break up the logic such that each column  does a portion, then have the
"final" column reference the "component" calculated  columns. Only
include the "final" in your list views.