A
Alro
Could someone help with the code for below:
In column 1 a value will be inserted ranging anywhere from 50 to 60
with increments of .5.
eg 50, 50.5, 51, 51.5, 52, 52.5 etc etc
When the value is added into column 1 another value appears in
adjacent cell in column 2.
eg
50 = 1.0
50.5 = 1.05
51 = 1.10
51.5 = 1.15
52 = 1.20
52.5 = 1.25
53 = 1.30
53.5 = 1.35
54 = 1.40
54.5 = 1.45
55 = 1.50
55.5 = 1.55
56 = 1.60
56.5 = 1.65
57 = 1.70
57.5 = 1.75
58 = 1.80
58.5 = 1.85
59 = 1.90
59.5 = 1.95
60 = 2.00
Any help is greatly appreciated
Al
In column 1 a value will be inserted ranging anywhere from 50 to 60
with increments of .5.
eg 50, 50.5, 51, 51.5, 52, 52.5 etc etc
When the value is added into column 1 another value appears in
adjacent cell in column 2.
eg
50 = 1.0
50.5 = 1.05
51 = 1.10
51.5 = 1.15
52 = 1.20
52.5 = 1.25
53 = 1.30
53.5 = 1.35
54 = 1.40
54.5 = 1.45
55 = 1.50
55.5 = 1.55
56 = 1.60
56.5 = 1.65
57 = 1.70
57.5 = 1.75
58 = 1.80
58.5 = 1.85
59 = 1.90
59.5 = 1.95
60 = 2.00
Any help is greatly appreciated
Al