Issues referencing data from another table

[bmoore45]

Hey guys,

I'm having trouble referencing data from another table in excel 2010 using the IF formula.

AIM: If cell a2=true, show value of cell a1
If cell a2=false, show X

This is what I've done;

Table 1

=IF('Table 2'!a2="TRUE",'Bayes modelling'!a1,"X")

However when I enter this the cell always reads as "X", whether or not the cell on the other table reads false.

Table 2

cell a2 uses the following expression;
=IF(P14>0.52,AND(P13<0.52))

cell a1 doesn't use a formula

I'm very new to excel but I'm guessing it is copying the formula rather than just the text.

Any help is greatly appreciated!

cheers,

Ben

 

[VoG]

Try removing the quotes around TRUE

=IF('Table 2'!a2=TRUE,'Bayes modelling'!a1,"X")

 

[bmoore45]

Thanks heaps mate, worked fine!