Value# error (2000)

Topic

New Reply

=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….

Reply | Quote

Replies

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)

Reply | Quote

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

Reply | Quote

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

Reply | Quote

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

Reply | Quote