• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 3. Building Basic Formulas > Using Reference Formulas

Using Reference Formulas

The reference operators combine two cell references or ranges to create a single joint reference. I discussed reference formulas in detail in Chapter 1, but Table 3.3 gives you a quick summary.

Table 3.3. Reference Formula Operators
OperatorNameDescription
: (colon)RangeProduces a range from two cell references (for example, A1:C5)
  (space)IntersectionProduces a range that is the intersection of two ranges (for example, A1:C5 B2:E8)
, (comma)UnionProduces a range that is the union of two ranges (for example, A1:C5,B2:E8)


  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint