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" wrote in message
...
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?