+ Reply to Thread
Results 1 to 3 of 3

Excel does not pull value from the cell - appears to pull formula

  1. #1
    Registered User
    Join Date
    06-16-2011
    Location
    Atlanta, georgia
    MS-Off Ver
    Excel 2007
    Posts
    2

    Exclamation Excel does not pull value from the cell - appears to pull formula

    For simplicity sake,

    Column A Column B Column C

    Columna A=iferror formula results in either a number or a blank cell
    Column B=If formula results in a number or "N/A"

    Column C needs to be Column B-Column A

    But every formula i have tried provides the #value error when
    column B is "N/A"
    OR when
    Column B is a positive number and column A is blank

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Excel does not pull value from the cell - appears to pull formula

    You can't subtract text, so try using:
    =N(B1)-N(A1)
    for example.
    Remember what the dormouse said
    Feed your head

  3. #3
    Registered User
    Join Date
    06-16-2011
    Location
    Atlanta, georgia
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Excel does not pull value from the cell - appears to pull formula

    Solved! Thank you so much!

+ 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] Pull Date from Previous Cell Unless blank, then pull from the next date to complete formul
    By lindseyjo in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-16-2014, 07:04 PM
  2. How to pull a formula from a cell in Excel
    By alexduy in forum Excel General
    Replies: 11
    Last Post: 12-05-2014, 07:43 PM
  3. [SOLVED] In cell C2, pull value from A2, but if blank or error, pull value from B2.
    By shepherdc2814 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-05-2013, 09:42 AM
  4. [SOLVED] Excel Formula to pull data from another sheet and place cell blank if value is 0
    By szpt9m in forum Excel Formulas & Functions
    Replies: 23
    Last Post: 09-18-2013, 01:07 AM
  5. [SOLVED] How to use two pull down lists to pull information from a third table
    By RibbleValley in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-09-2012, 07:45 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