Keeping track of inventory boxes

[Forre_Learning Excel]

I have the following formula . =IF(AND(F63 >= 85, F63 <= 100),"Pass","Fail")
After the cells are added this formula says pass if the contents in the box are greater then 85 but less then 100.
I want to when the condition is true and says pass I want to minus one box from the total of boxes received to keep track of inventory. The total number of boxes received is in cell C3. So every time we check contents in box are good then pass so up then minus one from C3.
Any Ideas
Thanks
John

 

[padapinto]

can you post a snap shot of your sheet

 

[Forre_Learning Excel]

I have the following formula . =IF(AND(F63 >= 85, F63 <= 100),"Pass","Fail")
After the cells are added this formula says pass if the contents in the box are greater then 85 but less then 100.
I want to when the condition is true and says pass I want to minus one box from the total of boxes received to keep track of inventory. The total number of boxes received is in cell C3. So every time we check contents in box are good then pass so up then minus one from C3.
Any Ideas
Thanks
John

Average Weight should be >85g and <100g
	Date:	Box #		Date:	Box #		Date:	Box #		Date:	Box #
	Initials			Initials			Initials			Initials
	Sheet No.	Weight (g)		Sheet No.	Weight (g)		Sheet No.	Weight (g)		Sheet No.	Weight (g)
	1			1			1			1
	2			2			2			2
	3			3			3			3
	4			4			4			4
	5			5			5			5
	Total	0		Total	0		Total	0		Total	0
	Average			Average			Average			Average

 

[Forre_Learning Excel]

So basically when you entered they fifth item meets the conditions and great the word pass. Then I want to minus 1 from the cell that had total boxes received . Be nice to have a message pop up saying when you get forty boxes should say Lowe of CCP
Thanks
John

 

[Forre_Learning Excel]

Any ides