+ Reply to Thread
Results 1 to 3 of 3

Formula answer does not appear in cell.

  1. #1
    Registered User
    Join Date
    07-24-2007
    Location
    London, England
    MS-Off Ver
    Office 365 ProPlus
    Posts
    80

    Formula answer does not appear in cell.

    Can someone help with the enclosed spreadsheet. There is a formula in columns I and J which should work when a number is put into columns E or G. However for some reason it is not working. It has been working fine. Can someone resolve the issue. Thanks Kevin in the UK using Excel 2002 SP3.
    Attached Files Attached Files
    Last edited by rushdenx1; 06-13-2010 at 05:10 PM.

  2. #2
    Registered User
    Join Date
    06-05-2010
    Location
    Fl, Usa
    MS-Off Ver
    Excel 2001
    Posts
    19

    Re: Formula answer does not appear in cell.

    I tried your sheet seems to be working ok here. I&J formulas all seem to be working.

  3. #3
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: Formula answer does not appear in cell.

    It seems the only problem is the "Calculations" are set to manual.

    Go to: "Tools > Options > Calculation" and set Calculation to automatic.

    Cheers,
    Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.

+ 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