+ Reply to Thread
Results 1 to 3 of 3

how do i get excel to automatically compute cell values

  1. #1
    talil
    Guest

    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. #2
    dlw
    Guest

    RE: how do i get excel to automatically compute cell values

    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. #3
    Duke Carey
    Guest

    RE: how do i get excel to automatically compute cell values

    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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1