IF-THEN-ELSE not working properly

Hi, this is my first time posting here. I've been searching for a thread that might be helpful for my current issue but could not find one.
these are the lines im having issues with:

Dim FNTotQty As String
          FNTotQty = Workbooks(wb).Worksheets(ws).Range("B43")

   If UCase(FNTotQty) = "QTY" Then
        For TotReb = 2 To z + 1
             Cells(TotReb, 26) = Cells(TotReb, 5) * Cells(TotReb, 6).Value
         Next TotReb
   End If

My goal is if all-caps variable FNTotQty is QTY then it should run the code above but it it is not the case. It does the opposite. If the actual value of FNTotQty <> QTY, the code will run. This is really weird. Help please.