I have 3 cells that need to work together. I want to enter the pay-rate(J2) for each person but I do not want to do it manually. I want to fill in J2 but off of logic using E2 and F2. For example, If E2 says "weekend" and F2 says "Day" then I want it to reference D2 from my other worksheet which is the value for weekday+Day = $10. So $10 would reflect back on my first sheet under pay-rate (J2).
I am assuming may need to some multiple statement to achieve this, however functions are not my strong suite in excel. I would also think it would be a very large logic to input all 6 combinations.
Here are all the payrate different combinations...
Different pay rate combinations (pic below, these values live on a different sheet)
Weekday Day $10
Weekday Evening $20
Weekday Night $25
Weekend Day $20
Weekend Evening $25
Weekend Night $30
1.PNG
2.PNG
Bookmarks