IF statement help. Graduating percentages.

New Contributor

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 Replies
best response confirmed by Hans Vogelaar (MVP)

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




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


File attached.



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