mercredi 11 août 2021

Tricky Excel IF formula: calculating one fee below a certain amount and another fee above a certain amount

I am trying to figure out how to calculate the following:

I have to calculate a fee of 5% for any amount between -100 USD and 100 USD, and a fee of 8% for any amount below -100 USD or above -100 USD and then sum both of these fee amounts.

E.g. A client has a negative balance of -123 USD (I am looking to calculate 5% for the first -100 USD and 8% for the rest -23 USD). Or other way around if he has a balance of 123 USD (I am looking to calculate 5% for the first 100 USD and 8% for the rest 23 USD).

I would greatly appreciate the help, because I cannot seem to figure out how to incorporate that it calculates both fees with different rates and then sums them together.

Aucun commentaire:

Enregistrer un commentaire