ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do i get excel to automatically compute cell values (https://www.excelbanter.com/excel-discussion-misc-queries/17971-how-do-i-get-excel-automatically-compute-cell-values.html)

talil

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

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.



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


"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