Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Automatically move to adjacent cells without hitting Enter | Excel Discussion (Misc queries) | |||
Enter multiple numbers in a cell so total shows when enter keypres | Excel Worksheet Functions | |||
Enter data and press enter to move to specific cell | Excel Programming | |||
How do I enter data in an adjacent cell based on a list selection? | Excel Worksheet Functions | |||
Auto enter date when data in enter in another cell | Excel Worksheet Functions |