Expression Icons

Showing Explanatory Icons for the Expressions

Other settings show icons for either or both the left-hand Expressions box and the right-hand Source/Results box.

In this example both left and right icons are showing.

 Note: Filing_Choice is a Named Formula and its Refers-To formula is shown expanded in the Treeview boxes.

Expression icons show the type of the expression:

 The Home Cell

 Range reference: Sheet1'!$A$1

    Reference is an empty Cell

 External reference: 'D:\Users\Charles Williams\Documents\[Book5.xlsx]Sheet1'!$A$1

 Structured reference: Table2[[#All],[married jointly]]

 3-Dimensional reference: Sheet1:Tax!B10:C16

 Individual Sheet reference from a 3-D Reference: Tax!B10:C16

 Named Range or Dynamic Named Range reference

 Named Formula (not returning reference): for example PISquared =PI()^2

   Named Variable within a LET function: for example X in LET(X,45,X+$A$1)

  Source reference, for example the source cell of a VLOOKUP result

 Reference result from Implicit Intersection with a row or column: Excel returns the value from the intersection of a named range or a range reference with the row or column of the formula. For example the formula =B:B in cell C5 will return B5.

  Reference result from Implicit Intersection when there is no intersecting row or column: returns #Null or #Value

 Reference result from Explicit Intersection of 2 references: K19:K30 H24:M24: returns #Null if there is no intersection.

 Reference result from intersection with used range. Most Excel functions will reduce large and whole-column references to the subset of the range that lies within the used range.

 Function expression that does not directly return a reference: SUM

Function returning a reference: OFFSET, INDIRECT, INDEX

 Expression that does not return a reference: A5*B5

 Expression returning a reference: INDEX($F$4:$F$7,2,1):INDEX($H$4:$H$7,4,1)

 Criteria expression in a SUMIFS, COUNTIFS, …IFS function, for example Table2[married jointly],">" & D5

 A constant, for example 4.5, “FastExcel”, True, #N/A

 An array of constants, for example {1,2,3;4,5,6}

 A Tooltip shown as an expression node in the TreeView

 A precedent range where every cell in the range contains a formula

 A precedent range where only some of the cells in the range contain a formula

A dependent range where every cell in the range has child dependents

A dependent range where only some of the cells in the range have child dependents

 The Root Cell for a Dynamic Array A Rich Data cell

Copyright © 2020 Decision Models Ltd