Absolute Reference Problem...

N

Nad

Hi Every One,
I am using Excel-2007.
I used this formula in cell R15C15
=$R12$C10*$R13$C10
But it is giving Error.

Pls. help

Regards,
 
R

Roger Govier

Hi

I think you will need to use
=R12C10*R13C10
You don't need the dollar signs to make R1C1 references Absolute.

To make them relative, you would use
=R[-3]C[-5]*R[-2]C[-5]
 
D

Debra Dalgleish

If you enter the formula in row 1, that will happen, because there's no
row that's 3 rows above row 1 ( R[-3] ).

Enter the formula in R15C15, that you mentioned in your first post, and
the formula should work correctly.

Thanks for help.
But when i wrote =R[-3]C[-3], it converts to R[65533]C[-3]

:
Click to expand...
 
Top