# Different tax bands

#### Confused78

##### New Member
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%

### Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
Is c8 also the dividend income reference, if not what is ?
What is the rate for under 37,500 and the rate for over 149,999 ?

What you seem to be asking for could be covered by something like this:
Excel Formula:
``=IF(AND(\$C8<=149999,\$C8>=37500),\$C8*33.75%,0)``
It would typically work more like this:
(with the 1st range not being 0)
Excel Formula:
``=\$C8*IF(\$C8>=150000,0,IF(\$C8>=37500,33.75%,0))``
If the dividend column is not the same as the income column change the first \$C8* to point to the right column.

Is c8 also the dividend income reference, if not what is ?
What is the rate for under 37,500 and the rate for over 149,999 ?
Hi thank you for your response the dividends income is in cell g8

Hi thank you for your response the dividends income is in cell g8
I should have also mentioned that the value in the dividend figure also needs to be within the same tax bands and not exceed the 149999 but be greater than 37500

Thanks for your response. I gather you were able to work out how to adapt one of my suggested formulas to meet your needs, so glad I could help.

Replies
1
Views
990
Replies
3
Views
434
Replies
24
Views
458
Replies
11
Views
561
Replies
14
Views
393

1,206,718
Messages
6,074,505
Members
446,072
Latest member
OrangeYellow

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back