Question:
In column Y i have numbers:
y2 = 8
y3 = 8
y4 = 8
y5 = 7
y6 = 6
y7 = 4
y8 = 1.5
and so on....
In column X I have text:
x2 = no
x3 = yes
x4 = no
x5 = yes
x6 = yes
x7 = yes
x8 = no
What I would like to do is where column X reads "No", in the corresponding Y cell I would like to multiply the existing value by 2.5 and have it become the new value for that cell. S
So for example, after I run the macro, the cell values would read as follows:
y2 = 20
y3 = 8
y4 = 20
y5 = 7
y6 = 6
y7 = 4
y8 = 3.75
Any idea how to do this on VBA?
Thanks!
In column Y i have numbers:
y2 = 8
y3 = 8
y4 = 8
y5 = 7
y6 = 6
y7 = 4
y8 = 1.5
and so on....
In column X I have text:
x2 = no
x3 = yes
x4 = no
x5 = yes
x6 = yes
x7 = yes
x8 = no
What I would like to do is where column X reads "No", in the corresponding Y cell I would like to multiply the existing value by 2.5 and have it become the new value for that cell. S
So for example, after I run the macro, the cell values would read as follows:
y2 = 20
y3 = 8
y4 = 20
y5 = 7
y6 = 6
y7 = 4
y8 = 3.75
Any idea how to do this on VBA?
Thanks!