| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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. |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Enter Data Into Another Excel File Automatically | Excel Worksheet Functions | |||
| Excel merged cell - can it automatically expand as text is typed? | New Users to Excel | |||
| Using Jet to read excel file returns blank for last cell - sometim | Excel Discussion (Misc queries) | |||
| how do i set up a single cell continual entry in excel to total f. | Excel Discussion (Misc queries) | |||
| Can Excel add a set percentage to a cell automatically when you type in a number | Excel Worksheet Functions | |||
Linear Mode
