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.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 Replies
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.
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.
