Excel always defaulting if-statement to false

[msf6fd]

I'm not sure why, but in my if-statement I sum up cells k2 through k4, which equals three as the condition in my if statement. I want the cell to check whether or not the sum is equal to I2(defined as IPB005_), and if it is, print the cell as a zero. If not, print it as a 1. For the life of me I can't figure out why it is always defaulting to false, and printing a 1. Any ideas? I'll post the workbook if anyone wants to take a crack at it. It is on sheet 2, and for the sake of testing, just iterate the workbook till I2 fills with a three so the numbers match up to the picture.

IMG-3.PNG

thanks for the help.
Work Book: https://drive.google.com/file/d/0Byc...w?usp=drivesdk

[TMS]

IPB005_ has an AVERAGE formula which displays as 5 but is actually 4.666666666667.

Please Login or Register  to view this content.

This COUNT(K2:K4) is 3, hence will not equal IPB005_ so you get the FALSE result which is 1.

As you drag down, the range will auto adjust and always equal 3.

[Estevaoba]

Try changing Inspection Date Generator!I2 to:

=ROUND(AVERAGE(IFEID2624601,A2),0)

[msf6fd]

Thanks! that makes a lot of sense.

[msf6fd]

Yup, that worked!