Gets or sets the precedents nodes which indicates what nodes affect the value of the current node.
There are following formulas:
|
Identity |
Formula |
A1 |
=B2+B3 |
A2 |
=SUM(B:B) |
B2 |
=C3+C4 |
B3 |
=0 |
C3 |
=1 |
C4 |
=2 |
Then the Precedents for each identity should be:
|
Identity |
Precedents |
A1 |
B2, B3 |
A2 |
B:B |
B2 |
C3, C4 |
B3 |
n/a |
C3 |
n/a |
C4 |
n/a |
Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6