SOLVED

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

Riny_van_Eekelen_0-1648114417518.png

File attached.

 

 

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