I would like to help with a formula for calculating commission based on a picklist and qty.

The name of the table is 'Vehicle Commission'

Picklist is 'Type'

Qty is 'Qty'

Rate is 'Rate'

The first 'vehicles' is complicated because it has thresholds.

If the quantity value is between 1-34 = £40(rate)

35-49 = £50(rate)

50 - 200 = £60(rate)

But i would also like to add in a picklist item:

'shipping'.  The calculation should be for qty*£40(rate)

'Finance' - qty*£40(rate)

'Currency' - qty*£40(rate)

Please can you help?