7 nested If's is the max, however if you create a formula with 7 If's and
name that formula something like "IF1", then create another 7 IF formula and
name it "IF2", you now have 2 7IF formulas you can put into another IF
formula such as IF(IF1,IF2,0). Excel now considers each named formula to be
only 1 argument.
Interesting workaround. Practically speaking 15 nested functions would be
extremely difficult to follow and manage. A VLOOKUP would be more easily
managed and understood.
JAN FEB, MARCH, ...upto DEC ARE THE COLUMN MONTHS WITH SALE TARGETS; Another
set of months coloumns (JAN,FEB , MARCH ... upto DEC) are the achievemnts. I
want to link month-wise ach (CELL IN " ENTER MONTH") and want to see
cumulative month-wise the status, progression etc. The achievement coloumn
will be filled in every month and the cumulative status vs targets seen just
by entering the month.
CUMULATIVE ACHIEVEMNETS vs CUMULATIVE TARGETS ENTER MONTH > FEB
TARGETS ACHEVEMENTS CUMULATIVE
JAN FEB MARCH DEC TOTAL TARGET JAN FEB MARCH DEC TOTAL TARGET ACHIEVEMNT
+ / - %
10 10 10 10 120 5 5 5 15 20 10 -50
Dear Harsh Bahal,
I have nested more than 100 IFs. Kindly send your e-mail address. I shall
reply you with examlpe. My e-mail is (e-mail address removed).
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.
