Looking for ON HAND inventory formula excluding damaged product

[fabian_76]

Hi Guys,

I hope there is someone that can help me with this formula. Please see the attached in Col R6 that I have the on hand inventory (with a formula) however when I fill the formula down I do not know how to ignore damage goods in order to keep having the on hand inventory formula.

Thanks,

[JohnTopley]

In R6

=R5+F6-I6

copy down

However, if "Material in Quality" and "Material Being Inspected" is part of the original inventory (of 2000) then these must be deducted if you require inventory AVAILABlE for sale.

[fabian_76]

Thank you John, your recommendation helped me to double check what i am doing.