Voting Question: Excel VBA Function UDF help (IF Else statements)?

This function should accept a number input (in this case the Sales value for the row it is on) and returns .10 if the input is over 200,000, .05 if the input is over 100,000, .04 if the input is over 75,000, .03 if the input is over 40,000, .02 if the input is over 20,000, .01 if the input is over 10,000, otherwise it will return 0.
Note: Make sure that you have values for Sales that enable you to test if your function is working correctly.
Note 2: You will use a User Defined Function in the VBA editing area and will need to use an If …then-ElseIf…Then-Else structure to accomplish this. Remember, to return a value we assign the function name to the return value INSIDE of the body of the function.

How would i go about doing this in excel?