I am creating a spreadsheet for a project where the specialists can just go to it and pick the "incentives" that they are giving out at events. It has drop down lists and a conditional drop down list of prices dependant on the item they select from a previous drop down list. I want to link this spreadsheet to an inventory in the same workbook. Essentially this is what I need...ie. If Jane inputs that she took 50 childrens books and returned with 5 books (meaning she gave away 45) then I need that to automatically deduct from the inventory on another sheet in the workbook. The trouble I am having is incorporating the drop down lists into a formula. I am stumped as to how to do this or if this is even possible. Can anyone help me? Im sorry if this sounds crazy...I am learning Excel. Please be a lifesaver! Thanks!
New to Excel and in need of a formula
- Thread starter Karla
- Start date
I am not able to get to my data right now but here is the formula that has half worked for me:
=IF('Incentive Tracker'!C2:C200="Cardio DVD",'Incentive Tracker'!D2:D200-'Incentive Tracker'!E2:E200,0)
So essientially when someone chooses "Cardio DVD" in any cell in row C...I need that to be counted and thus the values from column E to subtract from column F.
The problems I am having:
-ie. When I remove the :C200 from C2:C200 and just have the first part for C, D, & E the formula calculates how many items were chosen in the spreadsheet. How it is written now it will not work except for the corresponding cell on a different sheet. So if I input that exact formula in C6 and go to another sheet and choose the items in row 6 it will work; but not for any other cells/rows.
-I need this formula to be applied to the whole C column but I cannot figure out how to do it. I also need column E values to be subtracted from column D values.
I hope my explanation is clear enough! Thanks in advance!
=IF('Incentive Tracker'!C2:C200="Cardio DVD",'Incentive Tracker'!D2:D200-'Incentive Tracker'!E2:E200,0)
So essientially when someone chooses "Cardio DVD" in any cell in row C...I need that to be counted and thus the values from column E to subtract from column F.
The problems I am having:
-ie. When I remove the :C200 from C2:C200 and just have the first part for C, D, & E the formula calculates how many items were chosen in the spreadsheet. How it is written now it will not work except for the corresponding cell on a different sheet. So if I input that exact formula in C6 and go to another sheet and choose the items in row 6 it will work; but not for any other cells/rows.
-I need this formula to be applied to the whole C column but I cannot figure out how to do it. I also need column E values to be subtracted from column D values.
I hope my explanation is clear enough! Thanks in advance!