View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron@Buy Ron@Buy is offline
external usenet poster
 
Posts: 345
Default 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