Income tax formula

Didn't find your answer?

I am trying to work income tax out on a spreadsheet so we can work out tax on payroll and dividends 

I am struggling with a formula that if the taxable income on payroll (cell H8)is higher than 37500(cell L6) x (cell L8) 40% if not enter nil

Replies (8)

Please login or register to join the discussion.

avatar
By TheNovice
13th Jan 2022 19:55

This should work:

=if(H8>(L6*L8), 40%, 0%)

Let me know if it doesn't, I'll be more than happy to help.

Thanks (0)
Replying to TheNovice:
avatar
By Confused78
13th Jan 2022 20:07

Thank you for your response, it doesn’t work it just returns the value 0.40

Thanks (0)
Replying to TheNovice:
avatar
By Confused78
13th Jan 2022 20:07

Thank you for your response, it doesn’t work it just returns the value 0.40

Thanks (0)
Replying to TheNovice:
avatar
By Confused78
13th Jan 2022 20:07

Thank you for your response, it doesn’t work it just returns the value 0.40

Thanks (0)
Replying to Confused78:
avatar
By Hugo Fair
13th Jan 2022 21:35

It would help, when designing formulae in a spreadsheet, if you were a bit more precise as to what you wanted to achieve.

For instance:
* TheNovice's solution does exactly what you asked IF you wanted the result to show either 40% or 0% (as appropriate) ... because, say, you intend to multiply another value elsewhere (such as the result of (H8-L6) by the correct %age.
* Paul's solution goes a step further (by giving the result of multiplying (H8-L6) by the correct %age) ... which may be what you wanted, but means you don't hold intermediate values if you need them elsewhere in the spreadsheet.

Hope that helps ... meant as helpful explanation, not criticism.

Thanks (3)
Replying to Hugo Fair:
avatar
By Confused78
13th Jan 2022 22:50

Oh no it’s fine, I probably didn’t do a very good job at explaining as I tried a million ways myself and was getting annoyed with it

Thanks (0)
By Paul D Utherone
13th Jan 2022 20:24

=ROUND(MAX(0,H8-L6)*40%,2)

Thanks (2)
avatar
By Calculatorboy
14th Jan 2022 00:27

=if(h8>L6,(h8-L6)*L8,0)

Thanks (0)