Results 1 to 3 of 3

Thread: Please Help! Error message =#Value!

  1. #1

    Please Help! Error message =#Value!



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I received help on writing a complicated formula (complicated to me) the other day and have been using it, but every time I close the document and reopen, the cells containing the formula reads =#Value!

    I'm not sure what the problem is. This is what I'm trying to do:

    Cell K7 reference the value in Cell F7 and return a value from column N (which is based on the values incolumn M)

    I'm attaching a document and have highlighted the cells in red.

    Budget blank.xls

    Any help is greatly appreciated!

  2. #2
    your fringe rate k column contains
    #VALUE! as its value....there should be some numbers...bcoz of that u are getting #value error everywhere

  3. #3
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    794
    Articles
    0
    Excel Version
    2010
    Quote Originally Posted by bd88 View Post
    I received help on writing a complicated formula (complicated to me) the other day and have been using it, but every time I close the document and reopen, the cells containing the formula reads =#Value!

    I'm not sure what the problem is. This is what I'm trying to do:

    Cell K7 reference the value in Cell F7 and return a value from column N (which is based on the values incolumn M)

    I'm attaching a document and have highlighted the cells in red.

    Any help is greatly appreciated!
    Just to add a little to what jayajaya_4 is saying it would appear that you have lost the formulae that you had in Col K. This is probably because The formula you have entered is trying to carry out a calculation using the contents of column M. These contents are not numeric values, but a string or label that include some numeric symbols. You will need to make column M evaluate to a number or else use another source that does so instead. This will resolve the problem.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •