Results 1 to 5 of 5
  1. #1
    BakerMan
    Guest

    Value# error (2000)

    =IF(VALUE(X25=0),"",(E25+F25+G25+H25)*200000)/X25
    I get an error as the result of the formula shown. X25 contains another formula and it's value is 0. I tried ISERROR but I can't get it to work. TIA....

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Value# error (2000)

    The /X25 is outside the IF function, so you always divide by X25 even if it is 0. Try

    =IF(X25=0,"",(E25+F25+G25+H25)*200000/X25)

    or if X25 contains text values that look like numbers:

    =IF(VALUE(X25)=0,"",(E25+F25+G25+H25)*200000/X25)

  3. #3
    BakerMan
    Guest

    Re: Value# error (2000)

    Thanks HANS I knew it was simple. Where is a good reference to study up on entering functions?

  4. #4
    3 Star Lounger
    Join Date
    Jan 2002
    Location
    The Hague, Netherlands
    Posts
    283
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Value# error (2000)

    =IF(N(X25),(SUM(E25:H25)*200000)/X25,"")
    Microsoft MVP - Excel

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Value# error (2000)

    I guess most books about Excel cover this subject. You might try Book: Microsoft Excel Formulas by John Walkenbach.

Posting Permissions

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