I am not evaluating the logical operator of "equal to"
Dim Stage As String
If Range("I5") = "si" Then
Stage = "E"
ElseIf Range("I5") = "no" And Range("I9") > 1020 And Range("I9") <= 3100 Then
Stage = "
Execution of leasehold adjustments to existing infrastructure for use and operation for 10 years."
ElseIf Range("I5") = "no" And Range("I9") > 3101 Then
Stage = "Construction and operation of a collection center for recyclable waste for 10 years."
ElseIf Range("I5") = "si" And Range("I9") <= 1020 Then
Stage = "Construction and operation of a collection center for recyclable waste for 10 years.."
ElseIf Range("I5") = "si" And Range("I9") > 1020 And Range("I9") <= 3100 Then
Stage = "Stage Simulation 1: Construction and operation of a collection center for recyclable waste for 10 years."
ElseIf Range("I5") = "si" And Range("I9") > 3101 Then
Stage = "Stage Simulation 1: Construction and operation of a collection center for recyclable waste for 10 years."
End If
They know what I'm failing in my code
Aucun commentaire:
Enregistrer un commentaire