Limited IF Nested Level functions.

S

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

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
 

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

Excel 2003 - Nested IF functions, VLOOKUP, or something else? 2
If functions 3
Too many IF functions 4
Need loop structure to get round limited IF statements 5
Too many nested IF functions! 7
Nexted if()s are limited to Seven What other functions can I use? 8
nested if function 5
if statement" desperate insight is needed!!!!!! IF,Count, DCOUNT AHHHGGGGGGG! 1

Top