Hi,
My apologies in advance if this is a dumb question.
I begin with a figure of, say, $500,000 (eg Cell E8).
I take $70,000 at a rate of 2%.
The balance is rated at 4% and added to the above.
My formula now looks like this......=(70000*2%)+(E8-70000)*4%
The result is $18,600.
Using the above...