Private Sub CommandButton1_Click()
For x = 7 To 16
If Cells(x, "O").Value < "1.00" Then
Cells(x, "P").Value = 0.5
ElseIf Cells(x, "O").Value >= "1.00" And Cells(x, "O").Value < "1.50" Then
Cells(x, "P").Value = 1
ElseIf Cells(x, "O").Value >= "1.50" And Cells(x, "O").Value < "2.00" Then
Cells(x, "P").Value = 1.5
ElseIf Cells(x, "O").Value >= "2.00" And Cells(x, "O").Value < "2.50" Then
Cells(x, "P").Value = 2
ElseIf Cells(x, "O").Value >= "2.50" And Cells(x, "O").Value < "3.00" Then
Cells(x, "P").Value = 2.5
ElseIf Cells(x, "O").Value >= "3.00" And Cells(x, "O").Value < "3.50" Then
Cells(x, "P").Value = 3
ElseIf Cells(x, "O").Value >= "3.50" And Cells(x, "O").Value < "4.00" Then
Cells(x, "P").Value = 3.5
ElseIf Cells(x, "O").Value >= "4.00" And Cells(x, "O").Value < "4.50" Then
Cells(x, "P").Value = 4
ElseIf Cells(x, "O").Value >= "4.50" And Cells(x, "O").Value < "5.00" Then
Cells(x, "P").Value = 4.5
ElseIf Cells(x, "O").Value >= "5.00" And Cells(x, "O").Value < "5.50" Then
Cells(x, "P").Value = 5
ElseIf Cells(x, "O").Value >= "5.50" And Cells(x, "O").Value < "6.00" Then
Cells(x, "P").Value = 5.5
ElseIf Cells(x, "O").Value >= "6.00" And Cells(x, "O").Value < "7.00" Then
Cells(x, "P").Value = 6
ElseIf Cells(x, "O").Value >= "7.00" And Cells(x, "O").Value < "8.00" Then
Cells(x, "P").Value = 7
ElseIf Cells(x, "O").Value >= "8.00" And Cells(x, "O").Value < "9.00" Then
Cells(x, "P").Value = 8
ElseIf Cells(x, "O").Value >= "9.00" And Cells(x, "O").Value < "10.00" Then
Cells(x, "P").Value = 9
ElseIf Cells(x, "O").Value >= "10.00" Then
Cells(x, "P").Value = 10
Else
Cells(x, "P").Value = ""
End If
Next
End Sub
Bookmarks