+ Reply to Thread
Results 1 to 5 of 5

F2 Function won't work

  1. #1
    Registered User
    Join Date
    12-30-2013
    Location
    Boston
    MS-Off Ver
    Excel 2007
    Posts
    6

    Post F2 Function won't work

    Hello

    I have a formula in cell but if I press F2 to edit the formula and hit enter, the result of the formula disappears even though the formula is there. The cell is just blank. I'm using excel 2007. Please help

    Thanks

  2. #2
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: F2 Function won't work

    Hi and welcome to the forum! Do you know what kind of formula you have? If this is an array formula, it must be entered with Ctrl+Shift and Enter key combination in order to see the result.
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  3. #3
    Registered User
    Join Date
    12-30-2013
    Location
    Boston
    MS-Off Ver
    Excel 2007
    Posts
    6

    Thumbs up Re: F2 Function won't work

    Great,your suggestion worked. yes, i'm using array formula.

    Thank you very much.

  4. #4
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: F2 Function won't work

    You're welcome and thank you for the feedback!

    Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).

  5. #5
    Registered User
    Join Date
    12-30-2013
    Location
    Boston
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: F2 Function won't work

    Thanks for your help

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VBA FindNext function does not work in a function
    By ArnolddG in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-23-2013, 07:24 PM
  2. Getting a LIKE function to work?
    By Whizzo in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-13-2011, 10:56 AM
  3. Work day/ other function.
    By JamesGale in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-15-2009, 12:05 PM
  4. Work around to the 7 function limit with the IF function
    By Venka in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-11-2008, 07:02 PM
  5. How Does PMT function work ??
    By sandy3180 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-22-2006, 11:58 AM

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