Hi,
I need to calculate bands based on the below table, I need a value to be populated in column I based on the forecast hours/ productivity. Can anyone help with this?
So for example if the data in G3 = 52 & H3 = 105 then the output would be 1.5
Thanks
Johnny
Hours Sold Productivity
50-99.9 0.5 1 1.5 2
100-124.9 1.5 2 2.5 3
125-139.9 2.5 3 3.5 4
140> 3.5 4 4.5 5
Bookmarks