From: Ashish Mathur on 20 Mar 2010 23:08 Hi, I had authored a similar article on computing income tax payable based on slabs. You may refer to the solution (with explanation) here  http://ashishmathur.com/articles.aspx. Click on "Computing personal income tax" under B > 1  Regards, Ashish Mathur Microsoft Excel MVP "XKruodo" <XKruodo(a)discussions.microsoft.com> wrote in message news:0837A31BE72F4D8DB1BBD909F31F0E6B(a)microsoft.com... > 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? >
First

Prev

Pages: 1 2 Prev: How to enable auto height with merged cells? Next: retrieving current data 