tax rate calculation

Hi, I need some help on one formula I need the formula to be If taxable income in c8 (payroll income) is less than 149999 but greater then 37500 then multiple dividend income by 33.75%

I'm having difficulty coming up with a calculation to work out income tax based on some simple tax bands. I can do it in several steps using different columns to store intermediary results but I would really like to stick the calculation in a single column. My data is in rows, one row per pay...

Hi Excel experts, I'm trying to come up with a simple formula which will help me calculate the annual tax amount by simply entering annual gross pay in an workbook cell. The 2010 Australian tax personal income tax rates are listed in the table below. A 1.5% medicare levy is also added to your...