|There's a problem with your ranges.|
<= $750,000 includes all of the other values, as does <$750,000.01.
I assume that this is what you really mean:
< $285,714.30 3.50%
$285,714.30 to $500,000 $10,000
$500,000.01 to $750,000 $12,000
There are (at least) 2 ways to do this.
One is a brute force method using an IF function.
The problem with this method is that if the compensation ever changes, you'll need to change the formula.
Another, more flexible option is to use a VLOOKUP table. You should review the Help files on VLOOKUP to help you understand how this works.
Put this table somewhere in your spreadsheet...I'll use A11:B14.
11 0.00 =A1*.035
12 285714.29 10000
13 500000.01 12000
14 750000.01 15000
Then put this formula in B1:
=VLOOKUP(A1, $A$11:$B$14, 2, 1)
If the compensation ranges and/or the compensation amounts change, you can just change the table and never touch the formula.
Posting Tip: Before posting Data or VBA Code, read this How-To.