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