Excel formula

[Wild Bill]

I rarely use Excel, but I need help with this one problem.
I'm data logging some parameters on my race car and I need to apply a
constant to an entire column of data to get a correction factor.
Example:
Column M has 2700 lines of data. I need to divide each cell by a constant
and have that show in each cell of column N.
Please help me!

 

[JulieD]

Hi

you can use another cell somewhere, e.g. P1 and then the formula in N1 would
be
=M2/$P$1
you can then fill this down (move your mouse over the bottom right hand
corner of M2 until you see a + then double click or drag down the column)

if you don't want to use a cell to do this in you can use a range name,
choose insert / name / define - type a name (e.g. c_factor) and then in the
refers to box type the value (eg. =10) click ADD then OK
now in the first cell type
=M2/c_factor
and fill down

Cheers
JulieD

 

[Max]

One way ..

Assuming data starts in M2 down

Enter the constant into N1: 100 (say)

Put in N2: =IF(ISERROR(M2/$N$1),"",M2/$N$1)
Copy N2 down

 

[Wild Bill]

Thanks Julie!!!!!!!!!

 

[JulieD]

you're welcome

Thanks Julie!!!!!!!!!