Copying a formula from multiple workbooks down rows and across col

  • Thread starter Thread starter Rookie
  • Start date Start date
R

Rookie

Historically I had thought excell figured these patterns out and replicated
them but for the life of me I can't figure it out.

I have the following formula:=IF('Sales Price'!B3="","",'Sales
Price'!B3/'Sales Price'!F75) that Im trying to copy down multiple rows as
follows::=IF('Sales Price'!B4="","",'Sales Price'!B4/'Sales Price'!F75)

Im also trying to copy it across columns as follows: :=IF('Sales
Price'!C3="","",'Sales Price'!C3/'Sales Price'!F75)

The only real constant needs to be 'Sales Price'!F75, however it changes to
F76 when copying down rows and to G75 when copying across columns. Any help
would be much appreciated!
 
Use the absolute reference symbol "$" to lock a row/column reference. I think
you want:

=IF('Sales Price'!B3="","",'Sales Price'!B3/'Sales Price'!$F$75)

Note that I've locked the column and row of F75.
 
Back
Top