Nested if issue

[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.

 

[Pete_UK]

I think I responded to this yeserday - check your earlier posts.

Pete