You may try with:
=IF(H4<0,F4/H4*100,"")

Miguel.

"Bryan" wrote:

Hi,

By using the formula below i am trying to stop the cell in my spreadsheet
displaying #DIV/0! message. could someone offer me a suggestion to tweak it
so that it doesn't as i am stuck!

=IF(F4/H4*1000,F4/H4*100,"")

Many thanks,
Bryan