View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Richard Horn[_2_] Richard Horn[_2_] is offline
external usenet poster
 
Posts: 20
Default Percentage equals 0 error

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?