View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chris Chris is offline
external usenet poster
 
Posts: 71
Default #div/0 error help

I was hoping someone could help me out in making the #div/0 error
removed and replaced by a 0.
Here is my formulal:

=AVERAGE(IF('Filled All'!I1:I1000="JS",IF('Filled All'!
N1:N1000="IT",IF('Filled All'!B1:B1000="A",IF('Filled All'!
M1:M10000.001,'Filled All'!M1:M1000)))))

Any help is appreciated, Thanks!

-Chris