View Single Post
  #1  
Old April 8th, 2010, 11:41 AM posted to microsoft.public.excel.newusers
Dennis Gelso
external usenet poster
 
Posts: 1
Default i want to mutliply c10 to c20 by e4


e4=1.075

=c10*e4
=c11*e5 ( should be e4)
=c12*e6 (should be e4)
=c13*e7 (should be e4)


I want to copy the 1st formula and pull down the c11 to c20 but keep
the row number to stay the same (e4). I don't want e5 or e6. Iknow
there is a way to stop
e4 from Incrementing row numbers




--
Dennis Gelso