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

"Terry Pinnell" wrote:

Nad wrote:

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,

=$J$12*$J$13 works.

--
Terry, West Sussex, UK