I'm currently trying to get this statement to work but I've been having no luck.

I was wondering If when I'm using a macro to check a cell and that cell has a formula in it. does it find the formula/function or its answer.

I have this code 
If TSht.Cells(66, "Y") = 1 Then
                    
      .Attachments.Add (PRC)
and in cell 'Y66' I have this formula
Formula: copy to clipboard 
=IF( LEFT(F26, 1)="A", "1", "0")


Does the macro find Y66 as a '1' or does it just see the formula, because my macro isn't working and I'm unsure why.