ExcelBanter - Getting contents of adjacent cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Getting contents of adjacent cells (https://www.excelbanter.com/excel-discussion-misc-queries/264948-getting-contents-adjacent-cells.html)

Rocky

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

FSt1

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

All times are GMT +1. The time now is 12:44 AM.