Help With Conditional Formula

[Dsheaff]

I'm missing something!!... Hoping someone can help.

=IF(AND('QC W Beam'!O8=1,'QC W Beam'!I7="GUARDRAIL REPAIR (W & THRIE BEAM)"),'QC W Beam'!IM165,"")

This formula delivers the number 0 (zero) to the recipient cell (cell N56 on the worksheet titled QC Summary Rail.. The first and second elements deliver "TRUE" ... The third element 'QC W Beam'!M165 delivers 0 (zero). The referenced cell, M165, on the worksheet QC W Beam is filled with the value FAILED

All referenced and related cells are formatted as "General"

 

[jasonb75]

Now for a return trip to the optometrist.

That makes two of us, the typo was in the formula in post 1 and I missed it there