complex IF formula returns #VALUE!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

=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.
 
I'd change your formula to

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

You might want to check that Form!N1:N100 has values in it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Indirect in a Sumif Function returns the wrong answer 4
Formula result based on Multiple IFs 6
VLOOKUP to return a sum/0 instead of #N/A? 3
Validation based on values 1
Skip columns and copy formulas 15
'Named' formulas problem 1
Skip column cells and copy formulas 2
return adjacent cell's value based on formula 6

Back
Top