Thanks Everyone thats great all of the formulas worked well.

regards,
Bryan

"Mark Lincoln" wrote:

Try this:

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