View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default Row Variable assignment

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?