Forum home » Delegate support and help forum » Microsoft Excel Training and help » Relative vs absolute references in formulas
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Relative vs absolute references in formulas
Resolved · Low Priority · Version 2003
Reply Thu 7 Aug 2008, 16:42Delegate Lucia said...
Lucia has attended:
Excel Introduction course
Relative vs absolute references in formulas
what is a quick way to figure out whether to use one or the other?
For upcoming training course dates see: Pricing & availability
RE: relative vs absolute references in formulas
Dear Lucia
Thank you for attending Excel Introduction course. I hope you enjoyed the course and have benefited from it.
The best way to figure out if you need to use relative or absolute referencing then simply start with the relative referencing and copy the result to other cell. If you expected the one of the cell to remain same then you go back to the original formula and make the relevant cell Absolute.
I hope this helps!!
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000/2003
MCAS Master Instructor 2007
|