I am trying to create a worksheet to calculate commissions.

I am a REALTOR (anybody looking to buy or sell a home?)

I am trying to create a worksheet that will calculate my commissions. The
problerm is that my commission is based on the amount that has been paid to
the broker in the current fiscal year

If I have paid less than 28000, my split is 70/30. Once 28000 has been paid
to the broker, my split then becomes 100/0 split

Here are the critical columns (g,h,i)
Sale_Price : Brokerage_Percent :Brokerage_amount


This is the last way I have tried to get this working....

Sale_Price = the cost of the house
Brokerage_Percent =
=IF(SUM(I$2,ADDRESS(ROW()-1,COLUMN()+1,3))<28000,30,0)
Brokerage_amount = Sale_Price * Brokerage_Percent
This gives me a #value error

I have also tried stuffing a sum of Brokerage_Amount into a cell, and then
calculate brokerage_percent based on that cell. This gave me a circular
reference error.

There are 3 things I see wrong with what I am tring to do.

First, I am getting the errors (which I can see why, but not know how to get
around them)

The second is that as I get close to the 28000 threshold, I will need to
take just a portion of the commision reported by whatever calculation as the
correct amount of commission

The third (which I think I could figure out) is how to have the calculations
look only at the current fiscal year (right now, I might just use a new
sheet for each year)


How can I overcome these issues?

Bruce Johnson
www.YourAgentWithAHeart.com
bruce.at.YourAgentWithAHeart.com (remove the .at. and replace with @)