Different tax bands

[Confused78]

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%

 

[Alex Blakenburg]

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 ?

 

[Alex Blakenburg]

What you seem to be asking for could be covered by something like this:

=IF(AND($C8<=149999,$C8>=37500),$C8*33.75%,0)

It would typically work more like this:
(with the 1st range not being 0)

=$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.

 

[Confused78]

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

 

[Confused78]

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

 

[Alex Blakenburg]

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.