Forum Discussion
Solved
Inventory / stock checking discrepancy
Hello. I have done a stock check and would like to see the positive and negative quantities and costs. I don't know what formula I should use. The physical count of the stock is column D and the s...
- Hi there - thats right I'm looking for a formulae in I and J to show if there is a positive order negative amount and value
That works thank you. Except when saving to Sharepoint I get an error with the formula in column J it says #VALUE! and it says "a value used in the formula is the wrong data type"
helsbrooks1981 Know nothing about Sharepoint. Sorry! I copied the format from column G.