I am day to day user of Excel and need to develop spreadsheets models for
management accounting reports. However the application has a limitation on
nested level of up to 7 but my financial period has 12 months and it makes it
difficult to produce the right template. For example when I want the formula
to pick the 8th month totals, the nested IF function does not work. In the
old Lotus 123 spreadsheet, one was able to do this. Is there other way this
can be corrected?