how do i get excel to automatically compute cell values
I need to know how to get excel to automatically compute the cell values when
i'm changing it to a different number ex: My point threshold is 400, i cahnge it to 350, how do i make excel automatically convert the right average when any number is changed |
It's unclear from your post what you are trying to do. if you are
calculating the average of a list of numbers, when you change a number in the list, the average calculated by the formula changes. |
Go to Tools | Options & select the Calculation tab. Make sure either
Automatic or Automatic except tables is selected - not Manual Alternatively, you can leave Manual checked and, when you want to recalculate your spreadsheet, press the F9 key "talil" wrote: I need to know how to get excel to automatically compute the cell values when i'm changing it to a different number ex: My point threshold is 400, i cahnge it to 350, how do i make excel automatically convert the right average when any number is changed |
All times are GMT +1. The time now is 03:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com