Hello.

Does anyone know how to copy a formula while maintaining a constant value?
Ex.

A1 = 1000 SF (my constant value)
B1 = Material cost (currently blank)
C1 = Labor cost (currently blank)
D1 = Total cost (currently blank)

on another sheet (Rates) I have the pricing for the above blank cells.
I would like to enter the formula for just one of these (materials for ex.) and copy the formula to the rest of the cells (labor and total) while maintaining a1 as the constant value.

ex.
Formula for b1 would be:
=A1*Rates!B1

when I copy this formula to the next to cells on the right i get the following

for C1:
=C1*Rates!C1

for D1:
=D1*Rates!D1.

as you can see the first variable is changing. i need it to keep A1, the total SF.

Hope any one can help.

Thanks,