Row Variable assignment
=(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?
|