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

Try this:

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

Hope this helps.

Pete

On Feb 3, 1:04 am, AdzRay wrote:
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

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.

"Pete_UK" wrote:

Try this:

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

Hope this helps.

Pete

On Feb 3, 1:04 am, AdzRay wrote:
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

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


"AdzRay" wrote:

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.

"Pete_UK" wrote:

Try this:

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

Hope this helps.

Pete

On Feb 3, 1:04 am, AdzRay wrote:
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

=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

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

"Virg" wrote:

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


"AdzRay" wrote:

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.

"Pete_UK" wrote:

Try this:

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

Hope this helps.

Pete

On Feb 3, 1:04 am, AdzRay wrote:
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