I'm trying to create a spreadsheet for commission purposes.

Different commission percentages are paid based on a range of sales.

For example:

Sales between $80,000 to $100,000 earns 10% commission
Sales between $50,000 to $79,000 earns 8% commission, etc.

Does an array formula work for this? I've been trying to create one with no
luck

I appreciate any help