i want to mutliply c10 to c20 by e4

[Dennis Gelso]

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 kee
the row number to stay the same (e4). I don't want e5 or e6. Ikno
there is a way to stop
e4 from Incrementing row number

 

[John]

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

 

[trip_to_tokyo]

EXCEL 2007

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

If my comments have helped please hit Yes.

Thanks.