Prev: How to enable auto height with merged cells?
Next: retrieving current data
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:0837A31B-E72F-4D8D-B1BB-D909F31F0E6B(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