Copying a formula from multiple workbooks down rows and across col
 

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!

Copying a formula from multiple workbooks down rows and across col
 

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


$F75 or F$75 or $F$75


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=169152

Microsoft Office Help

Copying a formula from multiple workbooks down rows and across col
 

See above.

"Rookie" wrote:

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!

Copying a formula from multiple workbooks down rows and across col
 

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Rookie" wrote:

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!

Copying a formula from multiple workbooks down rows and across col
 

You need to make the reference to F75 asolute (using $)...

'Sales Price'!$F$75)

"Rookie" wrote:

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!