#VALUE in a formula cell?
 

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

#VALUE in a formula cell?
 

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

Which formula are you using?


--
Pecoflyer

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

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=61680

#VALUE in a formula cell?
 

Use the following Generic IF function:

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

Example:

=IF(ISERROR(A1+A2),"",A1+A2)
--
Kevin Backmann


"Fred" wrote:

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

#VALUE in a formula cell?
 

Kevin B;223200 Wrote:
Use the following Generic IF function:

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

Example:

=IF(ISERROR(A1+A2),"",A1+A2)
--
Kevin Backmann


"Fred" wrote:

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

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


--
Pecoflyer

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

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=61680

#VALUE in a formula cell?
 

I agree, I was just going with what information had been provided.
--
Kevin Backmann


"Pecoflyer" wrote:


Kevin B;223200 Wrote:
Use the following Generic IF function:

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

Example:

=IF(ISERROR(A1+A2),"",A1+A2)
--
Kevin Backmann


"Fred" wrote:

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

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


--
Pecoflyer

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

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=61680