Excel calculation problem
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Excel calculation problem

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    Montreal
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I am having trouble with Excel 2000. When I enter a simple formula in a cell the answer is incorrect. For example 5+5 equals 192086.
    Ive tried to reinstall MS office twice with no help.

    Thanks

    Rob M

  2. #2
    New Member
    Join Date
    Apr 2002
    Posts
    45
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    This maybe an obvious question, but did you check the formatting of the cell?

  3. #3
    New Member
    Join Date
    Apr 2002
    Location
    Montreal
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I was running a spreadsheet to do some complex calculations. I noticed alot of errors on the sheet. I opened a new file to test and noticed that it was not calculating correctly. This normally works at my office. This is the first time I tried to use Excel at home.

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    =5+5

    is 10

    (I can see you're impressed so far)

    as Christal mentioned, could it be formatting ?

    I formatted 10 as custom : yyyymd and it gave 1900110, which is close

    did you actually type 5+5 or were they linked to other cells with maybe rounding applied ?


    :: Pharma Z - Family drugstore ::

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com