Finding "CL" or "CLOSED" in one clumn and changing to 99% in Another

[Guzzlr]

For i = 9 To LastRow
If UCase(Cells(i, "F")) <> "CL" Or UCase(Cells(i, "F")) <> "CLOSED" _
And Cells(i, "B").Value = 100 Then
Cells(i, "B").Value = 99 _
And Cells(i, "E").Formula = "=(E-.3)"
End If
Next i

Hello All...
I have a little problem here.
What I'm trying to accomplish, is for the macro to not find either "CL" or "CLOSED" (upper case should not matter) in column "F" and a 100% in column "B", and changing 100% in Column "B" to a 99%, and then subtracting a .3 from the number in Column E...one row at a time.
The loop is working correctly.

Column "B" is formatted previously with:

With Range("B9:B6000")
        .Formula = "=1-(C9/D9)"
        .NumberFormat = "0%"
End With

What's happening, is every cell in Column "B", as the loop moves row-to-row, changes the number in column "B", regardless if it's 100% to 0%, and Column "E" number is not getting .3 subtracted.

Where am I going wrong this time!
Thanks for the help
excel 2013

 

[Guzzlr]

Check the value in col B, it probably isn't 1.

You're correct, the value was 99.7% and rounding up to 100%. I'm going to try putting in a greater than or equal to .995 and see if it works:

If Not IsError(Cells(i, "B").Value) Then
      If UCase(Cells(i, "F")) <> "CL" And UCase(Cells(i, "F")) <> "CLOSED" _
         And Cells(i, "B").Value >= 0.995 Then
            Cells(i, "B").Value = 0.99
            Cells(i, "E") = Cells(i, "E") - 0.3
      End If
   End If