I know that you can use a nested "if" function to create multiple conditions and if all of them are met, it will create a certain result. i am looking for a formula that will take multiple conditions and produce different results based on the criteria.
for example:
if "condition a" then "result a"
if "condition b" then "result b"
if "condition c" then "result c"
so lets say i have a column titled "kit type" if there are 5 different types of kits, i want to set it up to where once i enter the kit name into the column, it will reduce my stock of the individual items it takes to make that kit by a set amount.
for example, if Kit 1 requires:
2 of item A
5 of item B
10 of item C,
and Kit 2 requires:
3 of item A
7 of item B
2 of item C,
i want to be able to type in "Kit 1" and then have my on count of item A reduced by 2, Item B reduced by 5 ,and item C reduced by 10. OR type in "Kit 2" and have my count of items A, B, and C, reduced by the respective amounts. How could i go about doing this?
i hope this makes sense! thanks for the help!
Bookmarks