Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
what is absolute reference | Excel Discussion (Misc queries) | |||
Problem with Absolute reference | Excel Discussion (Misc queries) | |||
Excel too helpful! (problem with absolute reference) | Excel Worksheet Functions | |||
Absolute Reference | New Users to Excel | |||
absolute reference | Excel Worksheet Functions |