My IF AND Statement is working, but I think that once I add another employee it won't any longer. My statement takes the employees name and their position and then resolves a wage. It currently looks like this : =IF(AND(C10="James",D10="Journeyman"),Sheet2!$D$4,IF(AND(C10="James",D10="Apprentice"),Sheet2!$D$3,IF(AND(C10="Mickey",D10="Journeyman"),Sheet2!$D$6,IF(AND(C10="Mickey",D10="Apprentice"),Sheet2!$D$5,0))))
I'm trying to get the value of the hourly wage of a position for either a Journeyman or an Apprentice in a cell. One problem is that that position wage isn't the same for each employee. I have the names of the employees(column C), the positions (Column D) , and the wages on Sheet2!C. I'm currently only using the wage column (D) from sheet2, since I'm using specific text in my formula. I feel like there should be a much easier way for me to do this but I couldn't think of a way to express it in words that excel or google would understand. I tried to create a list of employee names and positions but I couldnt figure it out how that would help.
If I have ten employees I can't have the statement read IF(John and Journeyman=10),(John, Appren.=5), (Kevin and Journeyman=13),(Kevin and Appren=8) because it will end up being 20 different statments and if I ever added another position then it could get really messy fast.
Sorry if I'm a bit confusing. I'm trying to provide as much information as possible.
Bookmarks