Limited IF Nested Level functions.

[Skyscraper]

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?

[Bernard Liengme]

There are lots of alternatives such as a lookup function (VLOOKUP, HLOOKUP),
the SUMPRODUCT function etc. Please give more details of what you want to
do.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Skyscraper" <Skyscraper@discussions.microsoft.com> wrote in message
news:CF9E6ADE-A437-4D5A-93EE-4725F5E951A5@microsoft.com...
>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?