X
XKruodo
Hi,
I have a sheet with a table which has number of hours in a column A. Salary
per hour is in column B as under.
50 3.5
100 5.7
150 7.7
300 8.8
This is not just simple multiplication function. If you notice, first 3 rows
in A total up to 300 hours and 4th row has 300. It means that if someone has
worked for say 425 hours, I need to pay for first 50 hours 3.5 per hour, next
100 hours 5.7 per hour, next 150 , 7.7 hour and rest ( above 300 ) 125 hours,
8.8 per hour..
I have a cell that displays hours. How do i get values from this table?
I have a sheet with a table which has number of hours in a column A. Salary
per hour is in column B as under.
50 3.5
100 5.7
150 7.7
300 8.8
This is not just simple multiplication function. If you notice, first 3 rows
in A total up to 300 hours and 4th row has 300. It means that if someone has
worked for say 425 hours, I need to pay for first 50 hours 3.5 per hour, next
100 hours 5.7 per hour, next 150 , 7.7 hour and rest ( above 300 ) 125 hours,
8.8 per hour..
I have a cell that displays hours. How do i get values from this table?