I'm trying to create a spreadsheet to track inventory for my business. It's very simple but for some reason, i'm having difficulty with the nested IF's.
the top of the sheet will list total inventory of wines;
The user will select a type of wine, enter the quantity taken, and based on the selection and quantity, subtract the quantity from the total wine at the top.
Thanks for helping!
Help Article Resources
Check out the Formula Handbook template!