IF Formula

Giganews Newsgroups
Subject: IF Formula
Posted by:  Bryan
Date: Wed, 10 May 2006

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*100>0,F4/H4*100,"")

Many thanks,
Bryan

Replies