Calculation confusion
Hi I'm a bit of an Excel virgin.
I'm trying to set up a formula so a particular cell will show a running total of stock. exampe A1 quantity recieved today A2 total quantity recieved =A1+A2 A3 quantity dispatched today A4 total quantity dispatched =A4+A3 A3 shows current stock level. = A2-A4 However, everytime I edit a cell e.g quantity recieved today, all formulas update and not just the modified cell. how can i stop this happening? |
Calculation confusion
F1/ Circular reference
and then avoid using them. -- David Biddulph "L" wrote in message ... Hi I'm a bit of an Excel virgin. I'm trying to set up a formula so a particular cell will show a running total of stock. exampe A1 quantity recieved today A2 total quantity recieved =A1+A2 A3 quantity dispatched today A4 total quantity dispatched =A4+A3 A3 shows current stock level. = A2-A4 However, everytime I edit a cell e.g quantity recieved today, all formulas update and not just the modified cell. how can i stop this happening? |
Calculation confusion
Turn off automatic recalculation.
XL'07: Options, Formulas, Calculation options Earlier versions: Tools, Options, Calculation -- TedMi "L" wrote: Hi I'm a bit of an Excel virgin. I'm trying to set up a formula so a particular cell will show a running total of stock. exampe A1 quantity recieved today A2 total quantity recieved =A1+A2 A3 quantity dispatched today A4 total quantity dispatched =A4+A3 A3 shows current stock level. = A2-A4 However, everytime I edit a cell e.g quantity recieved today, all formulas update and not just the modified cell. how can i stop this happening? |
All times are GMT +1. The time now is 11:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com