Below is what I have my excel sheet set up right now. Basically what I want to do is on the "In Range?" section is say Yes or No depending on certain criteria.
So the date I have is for Friday which would be considered for the weekend. I need a function that if its Friday and we made $5320, to see the range under "Revenue" and pull that that the max hours is 160 And then check that against the Man Hours for the day which was "130" and if its less than the max hours it will say "Yes" in the Range column.
On Monday-Thursday it will pull from the Weekday hours and Friday-Sunday it will pull from Weekend hours.
Please let me know if this is at all possible or it would be too much of a mess. Thank you!
Date RevenueMan Hours In Range? Revenue Weekday Weekend Hours
12/2/2016 Friday 5320 130 ????? 0-1000 70 100
1001-2000 80 110
2001-3000 100 120
3001-4000 130 135
4001-5000 145 150
5001-6000 155 160
6001-7000 165 180
7001-8000 175 185
8001-9000 185 210
9001-12000 200 230
12001-15000 210 250
15001 240 275
rev
maxweekday
maxweekend
Bookmarks