blanking cells that contain #NUM!

M

Mat

Greetings

I have a formula that displays #NUM!. Is there any way of 'forcing' Excel
not to show this, or other error messages?
 
D

DDM

Mat, use the ISERROR worksheet function in an IF statement to check for
error values and suppress them. So:

=IF(ISERROR(Your Formula),"",Your Formula)

Just plug your formula into the formula above. I'm using Excel 2003, earlier
versions should work the same.
 
R

Ron Rosenfeld

Greetings

I have a formula that displays #NUM!. Is there any way of 'forcing' Excel
not to show this, or other error messages?
Click to expand...

You can use Conditional Formatting, with something like

Formula Is: =ISERROR(cell-ref)

and format the font to the background color (usually white).


--ron
 
D

Dave Hawley

Hi Mat

I woould use the Error.Type Function with an IF Function. I opt for
Error.Type over Iserr etc so that you are not hiding another error that
you should know about.

I would also return 0 if there is a #NUM! error as zero is more formula
friendly.

=IF(ERROR.TYPE(A1)=6,"Your Formula",0)

You can hide zeros via Tools>Options>View-Zero values Or via Custom
format like

0;-0;



** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***
 
Top