Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
problem with circular calcs
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
problem with circular calcs
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 "Ron@Buy" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simple Circular Reference Problem | Excel Worksheet Functions | |||
Problem with Circular Reference | Excel Discussion (Misc queries) | |||
Circular reference problem | Excel Discussion (Misc queries) | |||
Problem with IF function/circular/HELP! | Excel Worksheet Functions | |||
Circular Problem needs Macro | Excel Discussion (Misc queries) |