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 will say pass. When says pass then will take a subtract one box from the total in C3
Be nice when you get down to twenty boxes a message say inventory getting low
Any Ideas
Thanks
John
