Limited IF Nested Level functions.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exceeding Limit on Nested IF Statements 4
Nested Function Calls 3
Excel - exceed nesting levels 2
Creating Nested Functions 3
nested if with named formula 5
Nested Functions 7
Nested IF Formula 5
nested function 4

Back
Top