View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default Absolute Reference Problem...

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]

--
Regards

Roger Govier


"Nad" wrote in message
...
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,