Excel formula
 

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!

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


"Wild Bill" wrote in message
89.191...
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!

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

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Wild Bill" wrote in message
89.191...
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!

Thanks Julie!!!!!!!!!

you're welcome

"Wild Bill" wrote in message
89.191...

Thanks Julie!!!!!!!!!