Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Display in cell not the result of formula in cell

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

    Default

    In my spreadsheet, the number displayed in the cell is not the result of the formula in the cell. For example, if the formula is 10 + 5, the displayed result should be 15. But the number displayed is not 15. If the cell is edited, the display changes to the result of the formula. The spreadsheet is on automatic calc. If it makes a difference, the cells were created by a macro.


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

    what is displayed when 15 should be displayed ?

    what is also displayed when 200 should be displayed ?

    edit.... and what is the formula ?

    [ This Message was edited by: Chris Davison on 2002-04-29 10:59 ]

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

    Default

    The formula in cell c9 of tab A is: =if(current!$x9=0,"",current!c9/current!$x9). When current!c9=11,557 and current!x9=3,107,020, c9/x9=.0037196 but the number displayed in A!c9 is 2.30808. Cell c10 has the same formula copied down; when current!c10=15,879 and current!x10=2,766,635, c10/x10=.0057395 but the number displayed is 2.93708.

    The cells in current! are linked to tab Historic!. If the values in Historic! are changed, the display in A! will be updated to display the result of the division. However, the cells in Historic! will not be changed when working with this spreadsheet.

  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

    what's the macro ?

    (post the code if you can)

Some videos you may like

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
  •