Microsoft Office Tutorials and References
In Depth Information
Circular Reference Examples
Figure 16-6: This workbook uses circular references to calculate several recursive equations.
Solving simultaneous equations using a circular reference
In some cases, you can use circular references to solve simultaneous equations. Consider the two
simultaneous equations listed here:
3x + 4y = 8
3x + 8y = 20
You need to find the value of x and the value of y that satisfies both equations. First, rewrite the
equations to express them in terms of x and The following represents the first equation, y.
expressed in terms of x:
x = (8 – 4y)/3
The following equation represents the second equation, expressed in terms of y:
y = (20 – 3x)/8
As shown in Figure 16-7, cell B5 is named and cell B6 is named The formulas in these cells Y.
mirror the previous equations. The formula in B5 (X) is
=(8–(4*Y))/3
The formula is cell B6 (Y) is
=(20–(3*X))/8
The figure also shows a chart that plots the two equations. The intersection of the two lines
represents the values of X and Y that solve the equations.
 
Search JabSto ::




Custom Search