Nested If problem
Friends,
I want to evaulate 9 cells of different workbooks to check if they are empty and take value of the cell which is non empty(assuming only one cell contains value) into my master sheet. I will than plan to drag expand this cell to map all the cells accross the 9 workbooks. I can use this using nested if, however excel 2003 will allow for only 7 levels. Here is what I plan to do: =if(isempty('C:\[wrksheet1.xls]sheet1'!A1)=false,''C:\[wrksheet1.xls]sheet1'!A1,if(isempty('C:\[wrksheet2.xls]sheet1'!A1=false,'C:\[wrksheet2.xls]sheet1'!A1, ............if(isempty('C:\[wrksheet9.xls]sheet1'!A1=false,'C:\[wrksheet9.xls]sheet1'!A1))))))))) Is there any other way to do this. Thanks! |
Nested If problem
If the lack of nesting is the problem you can get around this limit by using
the last nesting to refer to another cell, then put the continuation of your nesting there. That way when your IF statements go to the last nest, it will pick up what is in the next cell, which should contain the answer you are looking for. Does that make sense? Squeaky "Harish Sharma" wrote: Friends, I want to evaulate 9 cells of different workbooks to check if they are empty and take value of the cell which is non empty(assuming only one cell contains value) into my master sheet. I will than plan to drag expand this cell to map all the cells accross the 9 workbooks. I can use this using nested if, however excel 2003 will allow for only 7 levels. Here is what I plan to do: =if(isempty('C:\[wrksheet1.xls]sheet1'!A1)=false,''C:\[wrksheet1.xls]sheet1'!A1,if(isempty('C:\[wrksheet2.xls]sheet1'!A1=false,'C:\[wrksheet2.xls]sheet1'!A1, ...........if(isempty('C:\[wrksheet9.xls]sheet1'!A1=false,'C:\[wrksheet9.xls]sheet1'!A1))))))))) Is there any other way to do this. Thanks! |
All times are GMT +1. The time now is 03:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com