Hi Community, formulas seem like a bit of a dark art to me so I have no idea where to start, tried a few things but getting nowhere fast!

I have what I think is a basic formula to write involving commission percentage amounts etc.

So a Price, a percentage commission amount of the Price paid to me, the remainder paid to the third party.

So for example, item is £1500 less 40%, £600 to me, £900 to third party. Percentage will be a variable.

Looks pretty straightforward here but not sure how to implement in Airtable. I have attached a screen grab of the relevant fields. The first row has been manually entered to show what I want the formula to do!

I hope all of this makes sense! It should be relatively simple to implement. The thing to remember with formulas is to make sure you pass in the proper type. You were probably really close, it’s just that since your commission rate was a number rather than a percent, you would have had to divide by 100 in your formula.