+ Reply to Thread
Results 1 to 5 of 5

Remove #VALUE! Error

Hybrid View

mbrady1973 Remove #VALUE! Error 12-09-2008, 09:29 AM
Ron Coderre Remove #VALUE! Error 12-09-2008, 09:56 AM
mbrady1973 Thank You 12-09-2008, 10:09 AM
rwgrietveld Just two alternatives: 1)... 12-09-2008, 10:18 AM
mbrady1973 OK How about removing #VALUE!... 12-09-2008, 11:33 AM
  1. 12-09-2008, 10:09 AM #1
    mbrady1973 is offline
    Registered User
    Join Date
    12-06-2008
    Location
    Syracuse
    Posts
    64

    Thank You

    Works Great
    Reply With QuoteRegister To Reply
  2. 12-09-2008, 10:18 AM #2
    rwgrietveld is offline
    Valued Forum Contributor rwgrietveld's Avatar
    Join Date
    09-02-2008
    Location
    Netherlands
    MS-Off Ver
    XL 2007 / XL 2010
    Posts
    1,671
    Just two alternatives:
    1) What if it is neither you might want to define 
    ...IF(J16="No Change",H16,"Wrong Input"))))
    And aonther apprach:
    =CHOOSE(MATCH(J16,{"Split Increase";"Give Back";"Roll Back";"No Change"},0),H16-(I16*0.5),G16,G16-(G16*0.05),H16)
    Looking for great solutions but hate waiting?
    Seach this Forum through Google

    www.Google.com     (e.g. +multiple +IF site:excelforum.com/excel-general/ )

    www.Google.com     (e.g. +fill +combobox site:excelforum.com/excel-programming/ )

    Ave,
    Ricardo
    Reply With QuoteRegister To Reply
  3. 12-09-2008, 11:33 AM #3
    mbrady1973 is offline
    Registered User
    Join Date
    12-06-2008
    Location
    Syracuse
    Posts
    64

    OK How about removing #VALUE! w/this formula..??

    =IF(J16="0",H16,G16+J16)


    Thanks...I don't know why I can't grasp this concept
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1