Forum Discussion
SUMPRODUCT formula persistent fail. UK Stamp Duty Formula
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.0...
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.