IF statement help. Graduating percentages.

[c_u_o]

I am trying to return a percentage in a cell where fees are charged as follows:

     First $1000 @ 1.2%

    Next $1000 @ 0.8%

    Balance over $2000 @ 0.5%

Any help is greatly appreciated.

[#2 · Accepted solution]

@c_u_o Create a table with the parameters as per your example and use a formula like:

=SUMPRODUCT((A7-lower)*diff,--(A7-lower>0))

where lower and diff are named ranges referring to parts of the parameter table.

File attached.

[#3]

@Riny_van_EekelenThank you for your response. This has helped me clarify my original query.