#div/0! how do i supress?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

On one of my worksheets I am creating a standard report that is doing quite a
number of calculations. On occassions my data in certain areas will be null.
For example cell H34 is returning the error because it has been looking for
type 5 priorities and there are none. I am a fussy person and want to
suppress the error message as it looks untidy. I have looked at a few threads
and cannot quite find one that sorts this out. Thanks up front to all you
patient people out there that take your time out to help others.
--
Regards vipa
.

Relevant Pages

  • Job submission to background and mail results?
    ... I wrote a .php script that does a lot of calculations, ... following error message: ... address, see a web message confirming that data was received properly, ... to submit the job so that the http connection is not alive and the rest ...
    (php.general)
  • Re: Guru needed-Calculations on one form?
    ... Steve Schapel, Microsoft Access MVP ... error message. ... I was not sure if I could do all the calculations at one time. ... For some reason it seems that the equation is not liked very well by access. ...
    (microsoft.public.access.forms)
  • Re: transfer programs in hp48gx to hp50s
    ... the depreciation calculations with the exception of CROSS ... resulted in the error message -> Error: ... System flag 42 was clear when I checked its status after I exited ...
    (comp.sys.hp48)
  • Re: stupid function
    ... It is not getting clear what "producing a mistake" means. ... If an error message appear, copy it and show the corresponding line here. ... If the calculated values do not match your expectations, show us the input value, the output value and your expectation. ... This method can be easily applied to other calculations also, ...
    (comp.soft-sys.matlab)