Hi everyone!
I'm trying to create an HLOOKUP formula that will match a number of sales with a commission % for 3 tiers. I haven't gotten too far with this despite it's simplicity. Please help! I'm getting frustrated.

The sales $$ are:
* $344
* $895
* $976

and the commission % are: over $900 is 4%, more than $600 is 2% and below $600 is 1%