After some searching in the forums, I wasn't able to find any info to help me out in my particular situation.

I think I may have crossed the threshold of my own abilities by trying to link cells to formulas in other worksheets within my workbook.

Let me try to explain myself:
I have 20 to 30 worksheets within my workbook. I would have created multiple workbooks, but so much of the data is linked between the sheets and I wanted to have it all in one file location. Anyway, I have a cell with the following formula in cell A6:
=IF(AND(E40>89, E41="Go", E42>89, I40>89, I41="Go", F8=0), "X", " ")

E40 is 80 which does not meet the first criteria to yield the TRUE value of X (all other criteria are met) - yet alas, there is an X in my cell.

It gets more interesting... I intended of having this data pulled from another worksheet.
While E40 shows 80, it is actually referencing a cell from another worksheet within my workbook. E40's fx ='M4 Scores'!F12

So - we go over to Worksheet 'M4 Scores' to cell F12 and this cell is also a formula:
=IF(E12<23,"No-Go",IF(E12<30,"70",IF(E12<36,"80",IF(E12<=40,"100"," "))))

This formula is dependent on E12's value, which is 35.

All the formulas work, except the first formula I mentioned:
=IF(AND(E40>89, E41="Go", E42>89, I40>89, I41="Go", F8=0), "X", " ")

The strange thing is that if I go back to the cell that alerted me to the problem (E40), and I manually type in 80 (which it already had displayed as a result from the formula), it instantly works.

If I evaluate the formula, the evaluation tells me that E40 is True - meaning that it is over 89, when it is clearly not. It is displaying an 80.

I am extremely confused. I have had other issues like this when referencing multiple formulas across multiple cells.

Can anyone help?

Thanks