#VALUE!
 

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

Sincerely,
Arturo

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

--
HTH

Bob Phillips

"Arturo" wrote in message
...
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

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!

"Arturo" wrote:

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

Sincerely,
Arturo

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

"Arturo" wrote:

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

Sincerely,
Arturo