I am part of an ecommerce site for second hand luxury items. I need some help with an equation to calculate the value sellers receive for their products. I am guessing will need to use the IF Function. The price is being split up.
Here is a breakdown of what a seller will receive.
On the first AED 400, you will receive 40%of the selling price.
On anything between AED 400 – AED 8000, you will receive 65%of the selling price
On anything exceeding AED 8000, you will receive 80% of the selling price.
Here is an example for you. If you are selling a handbag at AED 10,000 this is what you will get:
First AED 400- you will receive 40% of the value, that is AED160
For balance AED 8,000between AED400 – AED8,000 – you will receive, 65% of the selling price, that is AED 5,200
For balance AED 1,600 exceeding 2000 – you will receive 80% of the value, that is AED 1,280
Could you help me formulate this on airtable?
Thank you so much