Question about Microsoft MS Windows XP Professional SP2
From what I understand, you want to make a formula in MS Excel which will refer to itself. This is not possible.
You can make a target cell containing the information you need (variable, etc.), and work from there.
You can also get additional information from the Microsoft site.
Hope this helps.
Posted on Jun 27, 2009
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
Here's a link to this great service
Posted on Jan 02, 2017
Tips for a great answer:
Oct 17, 2014 | Microsoft Excel for PC
Oct 31, 2008 | Computers & Internet
Dec 17, 2009 | Microsoft Office Home and Student 2007...
Jul 08, 2009 | Microsoft Office Excel 2003 for PC
Jun 22, 2009 | Microsoft Excel for PC
Nov 20, 2008 | Microsoft Excel for PC
Jun 06, 2008 | Microsoft Excel for PC
Jan 01, 2008 | Microsoft Office Standard for PC
Relative cell reference is address of cell , when copied from one cell to another gets changed automatically.
e.g. Put formula in cell c5 as A5+1 when you copy this from c5 to c6 the address of A5 will automatically changed to A6.
Absolute Cell Reference
As above now put formula in cell C5 as $A$5+1 ,now copy this formula from C5 to C6 if you this formula youwill find cell Address of A5 does not changed.
Mixed Cell Reference:
If we put Dollar ($) sign before Alphabetic cell address i.e.$c5 then even if you copy this formula in any cell , coloumn (c) will remains constant.
Similarly if we put Dollar ($) sign before Numeric cell address i.e.c$5 then you copy this formula in any cell row address of the cell remains same.(5).
Pl elobarate on remaining two points 'Specific order of formulas ' and 'advance formulas,
Sep 15, 2007 | Microsoft Office Standard for PC
45 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: