Copying a formula from multiple workbooks down rows and across col

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!
 
J

joel

Putt a dolloar sign around the row and/or column will lock the referenc
cell


$F75 or F$75 or $F$7
 
L

Luke M

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying a formula with multiple worksheets down rows and across co 1
Copying down row to the next occurence in a different row. 1
Named Formula across multiple worksheets 4
Pricing from a table based on dimesions in 2 differnt cells (Excel 3
Insert a formula down 50,000 rows 4
Create multiple rows that follows a series 0
formulae to copy cells from 1 worksheet and paste into another? 8
I need to move the data from certain cells in multiple positions (different columns & rows) into a s 9

Top