| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Circular reference help please!
Hi
I have a problem with circular reference in excel. I need a total displayed in one cell address and i need it reduced accordingly by entries into another cell address. eg- A3 contains 1000. A20 is used for input and when operator puts in say 100 then A3 is reduced to 900. We need up to 30 consecutive inputs. Any help would be appreciated - Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Circular reference help please!
Are all cells A20:A49 to be subtracted from A3?
Where does the 1000 in A3 come from? Is that an input? Hans |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create dictionary of terms, create first time user site | New Users to Excel | |||
| Circular Reference... Help! | Excel Worksheet Functions | |||
| How can I avoid circular reference AND extra input | New Users to Excel | |||
| Iterate Circular Reference | Excel Discussion (Misc queries) | |||
| Help solve a Circular Reference | Excel Worksheet Functions | |||
Linear Mode
