I am Excel challenged and looking for assistance in creating a spreadsheet that provides calculation for the following commission plan:

1.0% on the first 45% of goal (say goal is $3,000,000), 1.5% on the second 45% of goal, and 2% above 90% of goal.

Your help will be greatly appreciated!

C.