Hi everyone,

Need some help here.

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