How To Fill Datagridview Colomn From Another Datagridview

[vher_way]

Morning All..
I need your help for my problem.
I want to fill my datagridview from another datagridview.

I have datagridview1 with data looks like the picture below:



and datagridview2:



Do you see the yellow colomn in datagridview1 and datagridview2?
I want make If Else Statement from datagridview1 for fill datagridview2:

The algorithm look like the code below :

If IPK[Datagridview1] > 3.75 Then IPK[Datagridview2] = 100

Elseif IPK[Datagridview1] > 3.50 AND < 3.75  Then IPK[Datagridview2] = 90

Elseif IPK[Datagridview1] > 3.25 AND < 3.5 Then IPK[Datagridview2] = 80

Elseif IPK[Datagridview1] > 3.00 AND < 3.25 Then IPK[Datagridview2] = 70

Elseif IPK[Datagridview1] > 2.75 AND < 3.0 Then IPK[Datagridview2] = 60

Elseif IPK[Datagridview1] > 2.50 AND < 2.75 Then IPK[Datagridview2] = 50

Elseif IPK[Datagridview1] < 2.50 Then IPK[Datagridview2] = 0

End If

How can i do that? Please teach me..