N/A in Linked Formula

[Rob33]

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??

 

[Aladin Akyurek]

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??

It's unclear what you want when '[ABC.xls]sheet1'!$X$28 houses an #N/A. Care to state your problem in words?

 

[Rob33]

#n/a in formula

I have a sheet that links to the "ABC" worksheet - Column X usually has a value in it but sometimes it returns a #n/a in column X - when it does this i need the formula to then read the value in column T

 

[Aladin Akyurek]

Re: #n/a in formula

I have a sheet that links to the "ABC" worksheet - Column X usually has a value in it but sometimes it returns a #n/a in column X - when it does this i need the formula to then read the value in column T

=IF(ISNA('[ABC.xls]sheet1'!$X$28),'[ABC.xls]sheet1'!$T$28,'[ABC.xls]sheet1'!$X$28)