+ Reply to Thread
Results 1 to 3 of 3

!VALUE# - I can't see what's wrong with the formula

  1. #1
    Registered User
    Join Date
    05-20-2013
    Location
    Apple Valley, MN
    MS-Off Ver
    Excel 2007
    Posts
    11

    !VALUE# - I can't see what's wrong with the formula

    J27 of my workbook looks to have the same formula as the rest of the J column, but is giving a !VALUE#. It's the same formula as on the worksheets from previous years and it's worked then. I can't see what is causing this, I've attached a copy of the sheet giving me this problem. Any help would be appreciated.
    Attached Files Attached Files
    Last edited by MadelynL; 08-21-2021 at 01:34 PM.

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.84 (24041420))
    Posts
    8,751

    Re: !VALUE# - I can't see what's wrong with the formula

    you have a space in G27
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Registered User
    Join Date
    11-20-2014
    Location
    Karachi, Pakistan
    MS-Off Ver
    2003
    Posts
    8

    Re: !VALUE# - I can't see what's wrong with the formula

    Hi,
    Just go to cell G27 and press delete in there
    There is a space in the cell

+ 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] is IF formula wrong here? or what am i doing wrong?
    By Sephre in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-22-2020, 02:19 PM
  2. What is wrong with this short formula ? (conditional formula)
    By Leo=123 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 10-01-2019, 06:53 AM
  3. [SOLVED] Macro exporting and saving the wrong page with wrong name
    By taylorsm in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-08-2018, 01:24 PM
  4. [SOLVED] Wrong formula or wrong function?
    By cpope in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-08-2017, 10:27 AM
  5. [SOLVED] What is wrong with this formula?
    By Bobz1983 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-07-2014, 04:54 AM
  6. [SOLVED] Doing Something Wrong with IF & OR & AND Formula -- Again
    By Leathermyth in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-05-2014, 11:29 PM
  7. What is Wrong with this formula please?
    By Issam LAdki in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 03-09-2005, 11:06 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