Related Topics:

Spreadsheets

Cell References

Two types of cell references are possible when entering a formula: absolute and relative.

Absolute references are designated by placing a dollar sign ($) in front of the row and/or column that is to be absolute. For instance, $A$1 is an absolute reference that points to the cell located in Column A, Row 1 regardless of the position of the cell containing the reference.

Referencing a Cell in a Different Sheet

To reference a cell in a different sheet from the one in which the formula is entered, use an exclamation mark (!) after the sheet name. For instance, =Sheet1!$A$1 is a reference to the cell located in Column A, Row 1 in Sheet 1. When referencing a cell in a different sheet from the one in which the formula is entered, the reference must be absolute. If the reference is not absolute, the calculations will not be carried out properly.

You can only reference sheets in the same analysis workbook, standard folio or DOE++ spreadsheet.

 

© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.