SUMPRODUCT formula persistent fail. UK Stamp Duty Formula

[Deleted]

Found the following well commented and working formula for calculating U.K. stamp duty

=SUMPRODUCT(--($B$3>{125000,250000,925000,1500000}), ($B$3-{125000,250000,925000,1500000}), {0.02,0.03,0.05,0.02})

however when I paste this into excel i get the following warning. Tried debugging, syntax everything but can’t see what I am doing wrong. Any help gratefully received!

[#2]

@Deleted 

The SUMPRODUCT evaluates as a valid formula on my machine.  Are there any spurious characters (maybe non-printing) in your formula?

You could try editing the formula to read

=SUMPRODUCT((amount>{125,250,925,1500})*(amount-{125,250,925,1500}),{0.02,0.03,0.05,0.02})

The product would remove the need for the double negative coercion from Boolean to numeric and at the same time replace the characters reported at the error point.

[#3]

@Deleted , try to check what are your default list separator (comma, semicolon) and decimal separator (dot, comma) and if you correctly use them in formula. I guess you are on iPad, don't know where such basic settings are for it.