You've got to detect and prevent the division by 0:
=if(h4=0,"",f4/h4*100)

"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