View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default 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