Excel Absolute/Indirect Problem

[RobbieBobbie23]

I have a simple formula in E6 (B6*C6). My problem is when I insert a new row into B6:C6, my formula in E6 changes from (B6*C6) to (B7*C7). I want the formula in E6 to ALWAYS be (B6*C6) no matter how many times I insert a new row into B6:C6. I've tried to use $B6*$C6 but it seems to change when I insert a new row. Your help is greatly appreciated.

[VBA Noob]

Maybe

=B$6*C$6

VBA Noob

[RobbieBobbie23]

that is not working....when I insert a row into B6 and C6; the formula in E6 changes to B7*B7

[RobbieBobbie23]

or if I delete the row; I get #REF!

[VBA Noob]

Try

=$B$6*$C$6

VBA Noob

[RobbieBobbie23]

Your answer is not working. It continues to change the formula if a new row is entered into B6 and C6

[Steve R]

Try formula =OFFSET(A1,5,1)*OFFSET(A1,5,2)

[Paul]

You can also try:

=INDIRECT("B6")*INDIRECT("C6")

Since the B6 and C6 aren't cell references, but text, they will not change when moved in any direction.