My IF statement won't work for my formula

[AdzRay]

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

 

[Pete_UK]

Try this:

=IF(B3="","",100%-H3/B3)

Hope this helps.

Pete

 

[AdzRay]

Thank you Pete for your suggestion. Unfortunately it didn't work, it changed
the error message to "FALSE" and the actual formula then didn't work once the
reference cells had data in them. However I appreciate you posting a
suggestion.

 

[Virg]

Try this one: =IF(B3=0,0,100%-H3/B3)
--
Virg

Thank you Pete for your suggestion. Unfortunately it didn't work, it changed
the error message to "FALSE" and the actual formula then didn't work once the
reference cells had data in them. However I appreciate you posting a
suggestion.

 

[Don Guillett]

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

 

[AdzRay]

Thank you so much! Your formula worked perfectly the cell remains blank until
it shows the required data. Thank you for posting your suggestion. Thank you
also to Don also for taking the time to respond to my question.
Cheers,
Adam