View Single Post
  #3  
Old April 8th, 2010, 02:54 PM posted to microsoft.public.excel.newusers
trip_to_tokyo[_3_]
external usenet poster
 
Posts: 932
Default i want to mutliply c10 to c20 by e4

EXCEL 2007

=(C10*$E$4)
=(C11*$E$4)
=(C12*$E$4)
=(C13*$E$4)

If my comments have helped please hit Yes.

Thanks.


"Dennis Gelso" wrote:


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
.