|
Explorer Pro Terminology
Expression/Subexpression
A valid fragment of a formula that Excel recognises and can convert or resolve to one or more values is called an Expression or Subexpression.
Formula:
=IF(F3=1,Z9*56,SUM(B10:B88))
Expression Fragments (these are all Child expressions of the Parent IF expression) :
F3=1
oF3
o1
Z9*56
oZ9
o56
SUM(B10:B88)
oB10:B88
Expression References, Source References and Restricted Source References
Explorer Pro recognises two different kinds of references, both of which are considered Precedents.
Expression References are visible references that can be seen in a formula:
F3 or B10:B88 or Sheet1:Tax!B10:C16
Defined Range Names : singlerow
Structured References to Tables: Table2[[#All],[married jointly]]
Expression References appear in the bottom left-hand Expression TreeView box.
Source/Result References and Restricted Source/Result References are references that are not visible in the formula but are produced as the result of evaluating Expressions or functions, or are the source of the results of an Expression:
INDIRECT, OFFSET and INDEX produce references when they are evaluated (the references may then resolve to values)
VLOOKUP(A1,B1:B10,1,False) contains 2 expression references (A1 and B1:B10), but has a Source Reference which is the actual cell in B1:B10 that the result is pulled from.
Explorer Pro will show the Source range the results came from for INDEX, MATCH, VLOOKUP, MAX, MIN, OFFSET, INDIRECT, CHOOSE etc., and also for Criteria expressions in SUMIFS type functions.
Full column references are often resolved to Restricted Source References because they are limited by the Used Range.
Range operations such as Implicit Intersection of named ranges resulting in a single source cell from the named range, explicit intersection of 2 ranges and the rarely used intersect operation also produce Restricted Source references.
Source References appear in the bottom right-hand Source/Reference box coloured Green
Restricted Source References appear in the bottom right-hand Source/Reference box coloured Orange
.
|
