Ignoring #VALUE! errors and MORE!!!!!

  • Thread starter Thread starter Romileyrunner1
  • Start date Start date
R

Romileyrunner1

Using the following formula:
=IF(ISERROR((BB25-AB25)/2),"",BB25-AB25)/2

But it comes up with #value! errors (some data not available in each BB or
AB column)
I can hide these with conditional formatting but I am then using the
following formula linked to that column of cells:

=SUMPRODUCT(($H$10:$H$89<2)*($I$10:$I$89>0)*($E$10:$E$89="Female")($BE$10:$BE$89))/SUMPRODUCT(($H$10:$H$89<2)*($I$10:$I$89>0)*($E$10:$E$89="Female"))

(The column witht the #VALUE! errors in is the BE10:BE89).

Any suggestions?? There must be a way of ignoring the error cells and just
extracting the data from the completed BE10:BE89 cells. OR do I have to do
something with BE10:BE89 cells in the first place to stop the #VALUE! errors
initially?

Many thanks you clever guys !!!!!
 
Move the division by 2 into the False part of your formula...

=IF(ISERROR((B25-A25)/2),"",(BB25-AB25)/2)
 
To explain... the #VALUE! error didn't come from the error produced by your
cells, it came from trying to divide text (in this case, the empty string ""
from your formula) by a number (in this case, the number 2).
 
Back
Top