View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Terry Pinnell Terry Pinnell is offline
external usenet poster
 
Posts: 46
Default Absolute Reference Problem...

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