Results 1 to 18 of 18

Calculation shows #N/A

Threaded View

  1. 05-06-2016, 10:54 AM #1
    KasperMikkelsen
    KasperMikkelsen is offline
    Registered User
    Join Date
    05-06-2016
    Location
    Copenhagen, Denmark
    MS-Off Ver
    MS 2013
    Posts
    27

    Calculation shows #N/A

    I'm trying to do a calculation in cell F4, where I refer to cell B5. However, the result becomes #N/A. Then, when I write "15-04", which is the value that cell B5 contains, it does work. Does any of you know what the reason could be for Excel displaying #N/A when I refer to the cell (I would like it to refer to the cell as the value is a calculation as well and thus will change in time).

    Best regards
    Kasper
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Automatic percentage calculation that shows the amount of cells changed in colour
    By johnson123 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-24-2015, 06:55 AM
  2. [SOLVED] Function Arguments window shows result, cell shows a 0
    By fluffsmckenzie in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-09-2013, 05:48 PM
  3. cell shows 20. Formula shows 20. why not 540/27
    By griswold in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 05:05 PM
  4. [SOLVED] cell shows 20. Formula shows 20. why not 540/27
    By griswold in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 04:05 PM
  5. cell shows 20. Formula shows 20. why not 540/27
    By William Horton in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 04:05 AM
  6. [SOLVED] cell shows 20. Formula shows 20. why not 540/27
    By griswold in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  7. [SOLVED] cell shows 20. Formula shows 20. why not 540/27
    By griswold in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-12-2005, 01: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1