Trying to get a function for a whole column...

[floyd605]

Hi. I am very new to Excel. I am trying to get the each cell in colum
L to be the answer to each cell in column K divided by 30. Hel
please! I know this is probably elementary for everyone here

 

[Peo Sjoblom]

One way

in L1 (or whatever the address is to the first adjacent cell in K)

=K1/30

copy down

 

[PegL]

In L1: =k1/30. Then copy L1 on down to the end of your
data. Assumes K has numbers in it.

 

[Guest]

Floyd,
A quick way to perform the copy down is to double click on the black square in the lower right corner of the selected cell.

Good Luck,
Mark Graesser
(e-mail address removed)

----- floyd605 > wrote: -----

Hi. I am very new to Excel. I am trying to get the each cell in column
L to be the answer to each cell in column K divided by 30. Help
please! I know this is probably elementary for everyone here.