blanking cells that contain #NUM!

  • Thread starter Thread starter Mat
  • Start date Start date
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?
 
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.
 
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
 
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 ***
 
Back
Top