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 |