#VALUE in a formula cell?

F

Fred

How do I avoid getting an #VALUE response in a formula cell without
zero-filling all of the cells being added etc?
Very fustrating
 
P

Pecoflyer

Fred;223151 said:
How do I avoid getting an #VALUE response in a formula cell without
zero-filling all of the cells being added etc?
Very fustrating
Click to expand...

Which formula are you using

--
Pecoflye

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows fil
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faste
 
K

Kevin B

Use the following Generic IF function:

=IF(ISERROR(YourFormula),"",YourFormula)

Example:

=IF(ISERROR(A1+A2),"",A1+A2)
 
P

Pecoflyer

Kevin said:
Use the following Generic IF function:

=IF(ISERROR(YourFormula),"",YourFormula)

Example:

=IF(ISERROR(A1+A2),"",A1+A2)
Click to expand...

Depending on the formulas used there are better options.
Thousands of VLOOKUPS for instance will take an eternity to calculat
this wa

--
Pecoflye

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows fil
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faste
 
Top