One way...

=IF(OR(H44=0,COUNT(G44:H44)<2),0,G44/H44)

--
Biff
Microsoft Excel MVP


"Richard Horn" wrote in message
...
I know if I ask for the percentage of =G44/H44 and both columns contain a
0,
or H44 contains a 0, Excel will return a #DIV/0! error. Is there anyway to
override that and display 0% until I actually get the numbers in there
from a
database query I need to run, which may be later in the year?