View Single Post
  #1   Report Post  
samshepcap samshepcap is offline
Junior Member
 
Location: In my house, or in my office
Posts: 1
Question What formula would i need for this??

I thought i had it with an IF formula, but i completely read the email wrong.

First/Second time buyers:
- On the first £250,000 of the value of the property 0%
- Balance above £250,000 up to £350,000 5.5%
- Balance over £350,000 3.5%

Third time (or over) buyers:
- Value of the property up to £200,000 0%

- Value of property between £200,000 and £350,000 2.0%
on the first £250,000 and 5.5% on anything exceeding £250,000

- Value of property exceeding £350,000 3.0%
on the first £350,000 and 3.5% on anything exceeding £350,000