how do i get excel to automatically compute cell values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rounds the large numeric value 2
Cell update - Automatically 1
Numbers change in cell even when formatted as text 4
how do I set the arrow keys to move only the highlight not the ta 1
Data being corrupted by excels automatic date recognition re-forma 6
How to synchronize all cell values? 1
Resize cell to fit picture 3
Changing the backcolor of a cell when data is added 1

Back
Top