We have a new tiered commission plan and I am trying to make a sheet that
shows the marketing reps how much revenue they have to bring in the following
month to average the amount needed to stay in the same tier and another
formula to show how much they need to bring in the following month to average
the amount needed for the next tier.

I have an equation that shows the information, but have not been able to
enter it as a formula into excel.

y + x / m /= z

y = revenue ytd total
z = tier level $ amount
x = new goal amt/current goal amt
m = no of months ytd

--
Jeannette