Hi, Vipa. It's ever so helpful to provide an edited formula if we have your
original formula, but here's a shot at it:

=if(iserror(yourformula),"",yourformula)
*******************
~Anne Troy

www.OfficeArticles.com


"vipa2000" <[email protected]> wrote in message
news:[email protected]...
> 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