Scribd
Upload
5 views1 page

Understanding Dependent Cells in Formulas

The document discusses formulas that contain references to other cells or named ranges. It provides examples of formulas that use relative references to cells on the same sheet or another sheet, and a formula that subtracts a cell named "Liability" from a cell named "Asset". It notes that the cell containing the formula is a dependent cell when its value relies on other cells. It also provides instructions for entering formulas, including selecting cells or named ranges to reference and using the formula bar.

Uploaded by

pksrikanth1
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
5 views1 page

Understanding Dependent Cells in Formulas

The document discusses formulas that contain references to other cells or named ranges. It provides examples of formulas that use relative references to cells on the same sheet or another sheet, and a formula that subtracts a cell named "Liability" from a cell named "Asset". It notes that the cell containing the formula is a dependent cell when its value relies on other cells. It also provides instructions for entering formulas, including selecting cells or named ranges to reference and using the formula bar.

Uploaded by

pksrikanth1
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd

A Formula that Contains References or Names

The following formulas contain relative references to and names of other cells.
The cell that contains the formula is known as a dependent cell when its value
depends on the values in other cells. For example, cell B2 is a dependent cell
if it contains the formula =C2.

Example formula What it does

=C2 Uses the value in the cell C2

=Sheet2!B2 Uses the value in cell B2 on Sheet2

Subtracts a cell named Liability from a cell


=Asset-Liability
named Asset

Notes:
1. Click the cell in which you want to enter the formula.
2. In the formula bar type = (equal sign).
3. Do one of the following:
To create a reference, select a cell, a range of cells, a location
in another worksheet, or a location in another workbook. You can
drag the border of the cell selection to move the selection, or drag
the corner of the border to expand the selection.
To create a reference to a named range, press F3,
select the name in the Paste name box, and click OK.
4. Press ENTER.

You might also like