Jul 22 2021 03:25 AM
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 stock that our system shows is column E.
Jul 22 2021 03:34 AM
@helsbrooks1981 Added some formulae in I and J. Is that what you had in mind?
Jul 22 2021 03:40 AM
SolutionJul 22 2021 03:43 AM
@helsbrooks1981 and you noticed the file I attached with the formulae in it?
Jul 22 2021 04:00 AM
Jul 22 2021 04:16 AM
@helsbrooks1981 Know nothing about Sharepoint. Sorry! I copied the format from column G.
Jul 22 2021 06:35 AM
And if before saving on Sharepoint convert it to xlsx format?
Jul 22 2021 03:40 AM
Solution