# Thread: Value# error (2000)

1. ## 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. ## 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. ## Re: Value# error (2000)

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

4. ## Re: Value# error (2000)

=IF(N(X25),(SUM(E25:H25)*200000)/X25,"")

5. ## 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
•