I have several rows of data
where I need to divide column a by column c
I'd like to somewhere on the sheet enter in
a cell M4, say the munber 25
and have a formula in M5 to
be = a(cellM4)/c(CellM4)
Can this be done?

Maybe
=indirect("a"&m4)/indirect("C"&m4)
or
=index(a:a,m4)/index(c:c,m4)



JMay wrote:

I have several rows of data
where I need to divide column a by column c
I'd like to somewhere on the sheet enter in
a cell M4, say the munber 25
and have a formula in M5 to
be = a(cellM4)/c(CellM4)
Can this be done?

--

Dave Peterson

Maybe......

=(A1*$M$4)/(C1*$M$4)

Vaya con Dios,
Chuck, CABGx3



"JMay" wrote:

I have several rows of data
where I need to divide column a by column c
I'd like to somewhere on the sheet enter in
a cell M4, say the munber 25
and have a formula in M5 to
be = a(cellM4)/c(CellM4)
Can this be done?

=(A1*$M$4)/(C1*$M$4) would be the same as =A1/C1, wouldn't it, Chuck?

I think the OP was looking at how to get A25/C25 in this case, so presumably
needs the INDIRECT function?
--
David Biddulph

"CLR" wrote in message
...
Maybe......

=(A1*$M$4)/(C1*$M$4)

"JMay" wrote:

I have several rows of data
where I need to divide column a by column c
I'd like to somewhere on the sheet enter in
a cell M4, say the munber 25
and have a formula in M5 to
be = a(cellM4)/c(CellM4)
Can this be done?