View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
smart.daisy
 
Posts: n/a
Default complex IF formula returns #VALUE!

=IF(AND(SUMIF(Form!I1:I100,"C",Form!N1:N100)-form2!G14<1.1,SUMIF(Form!I1:I100,"C",Form!N1:N100)-form2!G14-1.1),"ok","check")

I have a formula like this. I doubt check every cell and these related two
forms. They have valid data there. Could someone give me a hint where I might
find the problem? Thanks.