#VALUE!

A

Arturo

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
 
D

Dr. Nonverbal

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!
 
A

Ashish Mathur

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
 
Top