Nested if issue

H

Harish Sharma

Friends,

I am trying to compare cells of 9 seperate worksheets to evaulate if the
cell is an non-blank and store it in a master sheet. I will then drag and
expand the cell in master and map it with other cells in the 9 sheets.


It is very easy to accomplish using nested if, however excel will allow for
only 7 levels.

the formula is as follows:

=if(isblank('c:\[WBK1.xls]sheet1'!A1), 'c:\[WBK1.xls]sheet1'!A1,

if(isblank('c:\[WBK2.xls]sheet1'!A1), 'c:\[WBK2.xls]sheet1'!A1,
....
....
(isblank('c:\[WBK9.xls]sheet1'!A1), 'c:\[WBK9.xls]sheet1'!A1,


Can anyone suggest an alternative to accomplish this solution.
 

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

Top