I have a Formula where i want to link to 2 cells - one may have a N/A# my formula is:
=IF(+'[ABC.xls]sheet1'!$X$28="#n/a",+'[ABC.xls]sheet1'!$T$28,'[ABC.xls]sheet1'!$X$28)
my problem is that i can't get the formula to return a result due to the #n/a??
ANY IDEAS??
=IF(+'[ABC.xls]sheet1'!$X$28="#n/a",+'[ABC.xls]sheet1'!$T$28,'[ABC.xls]sheet1'!$X$28)
my problem is that i can't get the formula to return a result due to the #n/a??
ANY IDEAS??