CellSpace/Manual (draft)
by CellWorks
Home
  
Table of Contents
  
Glossary
Cell
Formula References
Cell
references are embedded in
Formula
and refer to the value of another
Cell
in a calculation. The standard notation is supported with
Sheets
. For example: 
  • 		=A42 + $B6 + AnotherSheet!G22 + AnotherServer.SomeSheet!C8
  • Also
    Items
    can be named in
    Sheets
    and
    Cubes
    are can referenced with those names. For example: 
  • 		=C$26 + Sales
  • Or: 
  • 		=Rows[21]
  • Or: 
  • 		=Columns[ABC]
  • Or: 
  • 		=mysheet[units, WestCoast]
  • Or: 
  • 		=AnotherServer.SomeCube[Sales, 'East Coast']
  • The system will reduce the reference to its simplest, unique form.
  • Single quotes are required when a
    Item
    name contains spaces or non-alpha-numeric characters.
  • The simplest and best way for form a
    Cell
    references it to click the referred
    Cell
    , outside of the formula editor, while editing a formula. The 'split' feature make this easy with large models.