=IF(LEN(B3)<2,"",100%-H3/B3)
or
=IF(OR(B3="",B3=" "),"",100%-H3/B3)

--
Don Guillett
SalesAid Software

"AdzRay" wrote in message
...
The formula I want to use is =100%-H3/B3. This is to give a failure ratio
for
products made. My problem is I have tried many IF statements so that if
the
cell reference is blank prior to having data in it the formula cell will
remain blank however at the moment because it knows the cell is empty it
comes up with an error meassge. #DIV/0!. The problem is that because it
is
filled down to 500 records when the person using it tries to print one
page
because it has the error message going down to 500 records excel assumes
you
want the whole 11 pages. Any help for an IF ststement that would result in
the cell reading blank instead of an error would be much appreciated,
Cheers,
Adam