i want to mutliply c10 to c20 by e4
 

e4=1.075 Tax

=c10*e4 original formula
=c11*e5 (should be e4)
=c12*e6 (should be e4)
=c13*e7 (should be e4)
=c14*e8 (should be e4)
=c15*e9 (should be e4)
=c16*e10 (should be e4)
=c17*e11 (should be e4)
=c18*c12 (should be e4)
=c19*c13 (should be e4)



I need to copy the formula C10*E4 to a hundred rows. I need E4 to stay the same and not Increment to e5,e6.e7.e8 ect. what do I put infront of e4 to stop it from incrementing

i want to mutliply c10 to c20 by e4
 

Hi Dennis
Try this =C10*E$4 or =C10*$E$4
First one locks the row# and the second one locks both Row and Column.
Type "Relative" in the Help window.
HTH
John
"Dennis Gelso" wrote in message
...

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

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
.