+ Reply to Thread
Results 1 to 5 of 5

Excel Formula not computing; Cell showing formula text

  1. #1
    Registered User
    Join Date
    06-01-2016
    Location
    Detroit, MI
    MS-Off Ver
    2016
    Posts
    14

    Excel Formula not computing; Cell showing formula text

    Hello,

    I am using the "VLOOKUP" function in several columns of my workbook. When I try to add a nested "IF.ERROR" statement, some of the columns (not all) suddenly only show the text of my formula (no calculation), as though I did not have the equal (=) sign before the formula. I've tried text to columns but nothing seems to be working. Any help would be appreciated.

    Thank you!

  2. #2
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Excel Formula not computing; Cell showing formula text

    Format the cells with the formula as General, then Re-Enter the formula.

  3. #3
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Excel Formula not computing; Cell showing formula text

    That usually means the cells are formatted as text.

    Change the cell format to General then re-enter the formulas.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  4. #4
    Registered User
    Join Date
    06-01-2016
    Location
    Detroit, MI
    MS-Off Ver
    2016
    Posts
    14

    Re: Excel Formula not computing; Cell showing formula text

    Great, thanks! It worked.

  5. #5
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Excel Formula not computing; Cell showing formula text

    Good deal. Thanks for the feedback!

+ 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. VBA to enter formula in cell not calculating...showing formula in cell
    By kmlloyd in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-09-2015, 06:42 PM
  2. 0 not showing up with text formula
    By cschulz349 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-03-2015, 01:28 PM
  3. [SOLVED] formula showing as text after macro entry
    By jprlimey in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-10-2014, 12:40 PM
  4. Vlookup formula showing as text in cell
    By Mile029 in forum Excel General
    Replies: 2
    Last Post: 09-15-2014, 10:17 AM
  5. I want a formula cell to be blank if cells computing formula are blank
    By asawyer3 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-20-2011, 05:24 PM
  6. showing formula as text string rather than result
    By censura in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-19-2007, 07:27 AM
  7. [SOLVED] Formula for computing work time in Excel
    By Alex Vinokur in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 09-20-2005, 02:05 PM

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