+ Reply to Thread
Results 1 to 14 of 14

Formula error

  1. #1
    Registered User
    Join Date
    02-11-2009
    Location
    Perth, Western Australia
    MS-Off Ver
    Excel 2003
    Posts
    3

    Formula error

    I have many spreadsheets with formula in them doing the basis calculations. For some reason instead of the answer to the formula displaying in the cell, the actual formula is showing instead of the answer to the formula. I sent a copy to a friend who opened the file up and the answer showed correctly.
    Last edited by mudraker; 02-20-2009 at 07:32 PM.

  2. #2
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Formula error

    Press Ctrl-`
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    “None of us is as good as all of us” - Ray Kroc
    “Actually, I *am* a rocket scientist.” - JB (little ones count!)

  3. #3
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Formula error

    jb what does that say?

  4. #4
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Formula error

    The same key as ~ on the unshifted level, I don't know what the character is called.

    So press Ctrl - `

    ...and formulas appear and disappear from view.

  5. #5
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Formula error


    '
    is that it?coz i have # on the tilde ~ key and cant see that symbol on my keyboard
    Last edited by martindwilson; 02-11-2009 at 09:40 PM.

  6. #6
    Forum Contributor mewingkitty's Avatar
    Join Date
    09-29-2008
    Location
    Fort McMurray, Alberta, Canada
    MS-Off Ver
    Excel 2003
    Posts
    949

    Re: Formula error

    It's a Tild
    For future reference.
    ~mew~



    Also for future reference - I can't spell TildE
    =IF(AND(OR(BLONDE,BRUNETTE,REDHEAD),OR(MY PLACE,HER PLACE),ME),BOW-CHICKA-BOW-WOW,ANOTHER NIGHT ON THE INTERNET)

  7. #7
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Formula error

    Foreigners! (huff!) Just kidding....

    My keyboard has a regular apostrophe leaning to the right or straight up, and that character which looks like an apostrophe leaning to the left.

    `

  8. #8
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Formula error

    Quote Originally Posted by mewingkitty View Post
    It's a Tild
    For future reference.
    ~mew~



    Also for future reference - I can't spell TildE
    No, Mew, this is a tilde

    ~

  9. #9
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Formula error

    ah i think this is it ` its the top most left on uk keyboard just below escape and amazingly it toggles formulas!
    Last edited by martindwilson; 02-11-2009 at 09:56 PM.

  10. #10
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Formula error

    the internet indicates this character is called: LEFT SINGLE QUOTATION MARK, GRAVE ACCENT

  11. #11
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Formula error

    no ,i think that was a surprised vincent price ! lol

  12. #12
    Forum Contributor mewingkitty's Avatar
    Join Date
    09-29-2008
    Location
    Fort McMurray, Alberta, Canada
    MS-Off Ver
    Excel 2003
    Posts
    949

    Re: Formula error

    That's coincidentally the key which my tilde is on

    ~
    `

    same key.

    mew.

  13. #13
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,677

    Re: Formula error

    Welcome to the forum, Lozza.

    Please take a few minutes to read the Forum Rules about thread titles, and then edit yours to make it descriptive of your problem.
    Entia non sunt multiplicanda sine necessitate

  14. #14
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Formula error

    Quote Originally Posted by mewingkitty View Post
    That's coincidentally the key which my tilde is on

    ~
    `

    same key.

    mew.
    try to keep up, hehe, I said that in post #4.

+ 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