View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 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?