I'm trying to create a calculated column containing more than 7nested "IF functions". How can I create a more elaborate formula whichexceeds that limit?
The only way is to create multiple calc. columns, each of themwith a max of 7 nested IF statements and then combine them in anothercalc. column.
What formula would I need to use to combine those columns together into a final column?
Break up the logic such that each column does a portion, then have the"final" column reference the "component" calculated columns. Onlyinclude the "final" in your list views.