complex IF formula returns #VALUE!

Giganews Newsgroups
Subject: complex IF formula returns #VALUE!
Posted by:  smart.daisy
Date: Fri, 12 May 2006

=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.

Replies