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

"samshepcap" wrote:
Subject: What formula would i need for this??
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

The rules are subject to interpretation. I assume the percentages are
applied to the property value. If not, you have not provided sufficient
information. Based on my assumption, try:

=ROUND(IF(P1<3,
SUMPRODUCT((V1{0,250000,350000})*(V1-{0,250000,350000}),{0,0.055,-0.02}),
IF(V1<=200000,0,
IF(V1<=350000,V1*2%+MAX(0,(V1-250000)*3.5%),V1*3%+MAX(0,(V1-350000)*0.5%)))),2)

where P1 is the number of properties (1, 2, 3 or more) and V1 is the
property value.

Change ROUND(...,2) to ROUND(...,0) if you want results rounded to pounds
instead of pence.

Be careful with curly braces v. regular parentheses. I suggest that you
copy-and-paste, then edit as needed instead of retyping from scratch.

The "percentages" within curly braces are expressed as decimal fractions.
For example, 5.5% is 0.055. The "percentages" are __differential__ values.
For example, -0.02 is 5.5% - 3.5%.

Similarly, the "MAX" percentages are differential values. For example, 3.5%
is 5.5% - 2%.