View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alro Alro is offline
external usenet poster
 
Posts: 8
Default 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