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
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
helsbrooks1981 and you noticed the file I attached with the formulae in it?
- 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"
And if before saving on Sharepoint convert it to xlsx format?
helsbrooks1981 Know nothing about Sharepoint. Sorry! I copied the format from column G.
