+ Reply to Thread
Results 1 to 5 of 5

#Value

  1. #1
    Forum Contributor
    Join Date
    03-18-2008
    Posts
    162

    #Value

    HTML Code: 
    =IF(T23="#Value!";"";S23)
    Hi guys why is it when i use this code its giving me a #Value?

  2. #2
    Forum Expert Simon Lloyd's Avatar
    Join Date
    03-02-2004
    Location
    locked in the cage
    MS-Off Ver
    All the ones my homepage shows
    Posts
    3,159
    If you really want to use that formula then here it is fixed!
    =IF(T23="#Value!","",S23)
    Not all forums are the same - seek and you shall find

  3. #3
    Valued Forum Contributor ratcat's Avatar
    Join Date
    03-07-2008
    Location
    Rural NSW, Australia
    MS-Off Ver
    Vista 2007
    Posts
    1,108
    G'Day,

    Since no one has replied

    My guess is the at the ! symbol is upsetting the formula.

    I try this in excel not as a html and it play up too.

    Maybe the formula is looking for a sheet reference with the ! symbol in the formula


    Edit: Kids distracted me from a quicker response
    Last edited by ratcat; 04-07-2008 at 07:25 AM.

  4. #4
    Forum Expert Simon Lloyd's Avatar
    Join Date
    03-02-2004
    Location
    locked in the cage
    MS-Off Ver
    All the ones my homepage shows
    Posts
    3,159
    Ratcat, i understand your thinking but the ! in the formula is formed as part of a string and as such excel sees it as a character rather than sheet notation, the problem with the original formula was because of a typo, Leighmills33 used (; )in his formula to separate the functions of the formula rather than (,) if you try the amended formula you should find it doesn't show #Value.

  5. #5
    Valued Forum Contributor ratcat's Avatar
    Join Date
    03-07-2008
    Location
    Rural NSW, Australia
    MS-Off Ver
    Vista 2007
    Posts
    1,108
    Quote Originally Posted by Simon Lloyd
    Ratcat, i understand your thinking but the ! in the formula is formed as part of a string and as such excel sees it as a character rather than sheet notation, the problem with the original formula was because of a typo, Leighmills33 used (; )in his formula to separate the functions of the formula rather than (,) if you try the amended formula you should find it doesn't show #Value.
    Knowing a little bit of html on notepad but not excel I though (; ) was the case and not (,) when scripting.

    Plus the kids are really on the ball tonight and I revised my test and its all my bad. The formula does work

    Thanks for the feedback

    Cheers

    ratcat

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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