Jess31
asked on
Excel cell reference?
Column C is Quantity. D is Quantity * .45 (actualy a more complicated formula but for clarity I'm using .45).
So row 2 - D2 = +C2 * .45. How can I instead refer to D2 as well as each row in D as a name? Like Quantity * .45
So row 2 - D2 = +C2 * .45. How can I instead refer to D2 as well as each row in D as a name? Like Quantity * .45
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Select a cell and type its name on the name box (near the formula bar)
cell-name.jpg
cell-name.jpg
@dougaug, in what way does this answer the question of how to use individual cells of a multi-cell range in a formula?
I assume you mean you are wanting to refer to the relevant cell in the column with the header Quantity for the row in which you are placing the formula.
In Excel 2003 - Bring up the Options window Tools > Options and select the Calculation tab. There is an option to "accept Labels in Formulas".
Hope this helps.
Cheers
Rob H
In Excel 2003 - Bring up the Options window Tools > Options and select the Calculation tab. There is an option to "accept Labels in Formulas".
Hope this helps.
Cheers
Rob H
In Excel 2003 and earlier click Insert - Name - Define, enter a name and select the range in the Refers to box.
In Excel 2007 and later click the Formulas Ribbon > Name Manager > New > enter a name and select the range in the Refers to box.
cheers, teylyn