We have business rules as follows:
- If it is bigger than £35 we charge 75% of it
- If it is smaller than £20 we charge 70% of it
- If is is between 20 to 35 we charge 72% of it
I don’t know how to set up a formula to automate this calculation in numbers. Is there a way to do this?