problem with circular calcs

  • Thread starter Thread starter ksfarmer
  • Start date Start date
K

ksfarmer

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
 
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?
 
Hi Ron,
Didn't make it clear on the first entry. Here's the issue.
1 Enter Multiple DIFFERENT numbers in Column A!.
2. Have them accumulate in Column B1
3. A price will be entered in Coilumn C1
4. Figure in Column B1 will be multiplied by the price in Column C1
5. Result will be kept in Column D1

The same scenario will be true for Rows 1 through 60.

Example: enter 10 in column A1 Column B1 will show 10
enter 35 in column A1 Column B1 will now show 35
Price in Column is 1.35 times 35 in Column B1 Show 46.75 in
Column D1
 
Back
Top