Assuming you always format the result cell as percentage - you may try this:
=IF(ISERR(1-H6/J4),"",1-(H6/J4))
In order to avoid the error.
Micky


"Memo Larach" wrote:

I'm using the following formula =100%-(H6/J4) to get a percentage,
however result is #DIV/0! error

Can anybody help with this error?


Thanks for your help