# Income tax formula

• ### how to threat company payment to directors

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)

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)
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)
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)
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)
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)
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)
By Calculatorboy
14th Jan 2022 00:27

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

Thanks (0)