I am looking to create a formula to calculate tax payments. If cell x is greater than £11000, then calculate the excess at 20% of the excess figure. i.e. Cell A1 £12000, Cell B1 would thus be £12000-11000 = £1000 * 20% = £200. If cell A1 was £10000, value in B1 would be 0.
Can anyone help?
Thanks