Consulting

Results 1 to 9 of 9

Thread: "IF" statement isn't reading binaries properly

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    "IF" statement isn't reading binaries properly

    Hello, I'm writing an "IF" statement that checks two binaries for me. It is written as such:
    If Range("L70").Value = 1 Then
    Range("K37") = "Pass"
    ElseIf Range("B70").Value = 1 And Range("L70").Value = 0 Then
    Range("K37") = "Fail"
    Else: Range("K37") = "DNP"
    End If
    However, despite L70's value being 0, it still changes K37 to "Pass." What am I writing wrong in this statement?
    Last edited by Aussiebear; 09-15-2024 at 10:31 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •