There are different tables. Different for say supervisors , managers etc..
And table has more than 10 slabs. "IF" function wont work as i cannot use
"IF" more than 7 times in single formula..

"XKruodo" wrote:

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?