Hello. infrequent user here.
I am setting up a simple inventory of a single item. I made add or delete from the inventory on any given day. I have a Quantity on Hand cell at the top of a column which is simply the sum of the cell values below it. I know that I can put a NEG sign before a numeric entry and it will properly subtract that value from the Quantity on Hand. What I would like to do is remove the potential for a wrong sign by determining the =/- value of my numeric input based on whether the text chosen from my drop down list in the preceding cell is "add to quantity on hand" or "subtract from quantity on hand".
Any ideas? I've run through the forum and didn't find anything, and I've about pulled out all my hair trying to understand the HELP files and online explanations.
Cheers,
Megan
I am setting up a simple inventory of a single item. I made add or delete from the inventory on any given day. I have a Quantity on Hand cell at the top of a column which is simply the sum of the cell values below it. I know that I can put a NEG sign before a numeric entry and it will properly subtract that value from the Quantity on Hand. What I would like to do is remove the potential for a wrong sign by determining the =/- value of my numeric input based on whether the text chosen from my drop down list in the preceding cell is "add to quantity on hand" or "subtract from quantity on hand".
Any ideas? I've run through the forum and didn't find anything, and I've about pulled out all my hair trying to understand the HELP files and online explanations.
Cheers,
Megan