problem with circular calcs
Tried your scenerio - works fine:
Enter numbers in column A, B1 =A1, enter numbers in column C, D1 = B1*C1,
B2 = B1+A2 copy down, D2 = B2*C2+D1 copy down
How do you get a circular reference?
"ksfarmer" wrote:
I have an issue. Here's the setup
Let's use this setup. 4 columns x 60 rows. Call them A B C D
1 Enter multiple numbers in column A
2 Have them accumulate in Column B
3 Multiple the number in column B by a number in column C
4 Have the extended value accumulate and store in column D
|