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
.
|