#VALUE!

[Guest]

Hi,
I have inherited a file…
There are numerous types of formulas displaying #VALUE! That I want
displaying nothing instead of #VALUE!. I’m searching help files but am not
find a catch all control to key in. Research suggestions appreciated.

Sincerely,
Arturo

 

[Bob Phillips]

=IF(ISERROR(formula),"",formula)

 

[Guest]

Hello Arturo,

The solution is the ISERROR formula. You can use an IF formula to create
something like this:

=IF(ISERROR(A2)="TRUE","",<REST OF FORMULA>)

A2 = The cell in question.
<REST OF FORUMLUA> = Place the rest of your origial formula here. Remember
to put a close parenthesis at the end of your modified formula.

This addition will return a blank cell if the value returned would otherwise
be #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!.

Good luck!

 

[Guest]

Hi,

Try this. Select the list of numbers and then Ctrl+G, Select Special and
then in formulas select error values (uncheck all other optiosn under
Formulas). Now all the error vales will get highlighted. Simply type 0 and
press enter (Enter will take you to the next error value cell.

Regards,

Ashish Mathur