Absolute Reference Problem...
 

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,

Absolute Reference Problem...
 

A complete guess but try this:-

=J12*J13

Mike

"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,

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,

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

Absolute Reference Problem...
 

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

Absolute Reference Problem...
 

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.


Nad wrote:
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




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html