how do i get excel to automatically compute cell values

T

talil

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
 
D

dlw

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.
 
D

Duke Carey

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
 
Top