enter a set value in adjacent cell

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
 
N

NickHK

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.
 
A

Alro

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.











- Show quoted text -

Thanks, works a treat
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top