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

F

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
 
P

Peo Sjoblom

One way

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

=K1/30

copy down
 
P

PegL

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

Mark Graesser

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
[email protected]

----- 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.
 
Top