Hi

I have a link to another spreadsheet in a cell (C8) which returns a value
"TEST"

I want to use this value in another formula, in this case an IF statement.

Example

=IF(C8="TEST",H81250/1250,"N/A")

However i cant get the formulae to work because I suspect that even although
cell C8 returns a value of "TEST" that the formula is actually reading the
"link formula" which returns the result "TEST"

How do I get my formula to recognise the word "TEST" instead of the formula
that returns it?

Thanks in advance

John