enter a set value in adjacent cell
 

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

enter a set value in adjacent cell
 

Assuming your initial values in column A:
=1+(A1-50)/10

Maybe look at using the Worksheet_Change event if you need it be automatic.


"Alro" wrote in message
oups.com...
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

enter a set value in adjacent cell
 

On Jun 6, 5:53 pm, "NickHK" wrote:
Assuming your initial values in column A:
=1+(A1-50)/10

Maybe look at using the Worksheet_Change event if you need it be automatic.

"Alro" wrote in message

oups.com...



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- Hide quoted text -

- Show quoted text -

Thanks, works a treat