+ Reply to Thread
Results 1 to 7 of 7

Basic formula producing #VALUE!

  1. #1
    Registered User
    Join Date
    01-14-2013
    Location
    Phoenix, Arizona
    MS-Off Ver
    Excel 2010
    Posts
    14

    Basic formula producing #VALUE!

    I have a spreadsheet and I am trying to subtract a value in column A with the value in column B and I cannot seem to get a numerical value. It keeps reflecting #VALUE!.

    Can anyone help me?

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

    Re: Basic formula producing #VALUE!

    Sounds like either A and/or B is not a real number, just a text string that looks like a number.

    What do these return
    =ISNUMBER(A1)
    =ISNUMBER(B1)

  3. #3
    Registered User
    Join Date
    01-14-2013
    Location
    Phoenix, Arizona
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Basic formula producing #VALUE!

    A1 = false
    b1 = true

  4. #4
    Registered User
    Join Date
    01-14-2013
    Location
    Phoenix, Arizona
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Basic formula producing #VALUE!

    I am having trouble getting the numbers in column A into a real number. When I use the VALUE formula, it returns #VALUE!

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

    Re: Basic formula producing #VALUE!

    What is actually in A1 ?

    Can you post a sample file?
    Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

  6. #6
    Registered User
    Join Date
    01-14-2013
    Location
    Phoenix, Arizona
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Basic formula producing #VALUE!

    I actually tried attaching my spreadsheet to the original post multiple times but it wouldn't upload even though it was only 13 KB. Regardless, I was messing around and just figured out how to get the value into a real number.

    If anyone reads this later and wants to know what I did, I am providing the info below.
    My values in column A and B looked like this: 11111111.
    I copied the values in column A and pasted it into notebook.
    When I pasted it into notebook, the number looked like this: "11111111".
    In notebook, I chose Edit, Replace, Find What = ", and chose replace all.
    The " around the number was then removed.
    I then copy and pasted the numbers from notebook into excel and it worked.

    Thank you for trying to help!

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

    Re: Basic formula producing #VALUE!

    Glad you got resolution.

    Excel should be able to do that as well with the Find/Replace tool to remove the quote marks.

+ 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. Networkdays formula producing negative result
    By jeni2015 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-01-2015, 03:45 PM
  2. [SOLVED] IF formula using dates not producing correct result
    By Snelms in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-14-2014, 03:48 PM
  3. Replies: 2
    Last Post: 08-24-2014, 04:56 AM
  4. Producing discount code in visual basic
    By pbaynham in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-17-2009, 02:56 PM
  5. Formula producing inconsistent results
    By joseclar in forum Excel General
    Replies: 5
    Last Post: 05-20-2009, 01:41 PM
  6. vlookup + array formula producing #Value!
    By lnjr in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-28-2008, 07:22 PM
  7. [SOLVED] How do I move only value producing formula to another column ??
    By colwyn in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-24-2008, 02:41 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