| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting contents of adjacent cells
I want to divide the y1-axis column and save it to radius (y1/2) column. How
do I do that? x-axis y1-axis radius(y1/2) 0 0.00 8.0000 1 0.25 8.0242 2 0.50 8.0691 3 0.75 8.1281 4 1.00 8.1989 5 1.25 8.2803 6 1.50 8.3716 7 1.75 8.4729 8 2.00 8.5832 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Getting contents of adjacent cells
hi
divide the y1-axis by what? 2 as an guess with y1-axis in column c in the y1/2 column(d?), enter =C2/2 copy down. regards FSt1 "Rocky" wrote: I want to divide the y1-axis column and save it to radius (y1/2) column. How do I do that? x-axis y1-axis radius(y1/2) 0 0.00 8.0000 1 0.25 8.0242 2 0.50 8.0691 3 0.75 8.1281 4 1.00 8.1989 5 1.25 8.2803 6 1.50 8.3716 7 1.75 8.4729 8 2.00 8.5832 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add cells on two adjacent rows but non-adjacent columns | Excel Worksheet Functions | |||
| Display contents of adjacent cells | Excel Worksheet Functions | |||
| How do I exchange cell contents between two non-adjacent cells? | Excel Discussion (Misc queries) | |||
| sum cells based on contents of adjacent cell (validated list)? | Excel Worksheet Functions | |||
| Displaying contents of adjacent cells. | Excel Discussion (Misc queries) | |||
Linear Mode
