Not sure if this is what you wanted, but check out this file, it has formula to calculate Tier basing on your input including:
B2: Base
B3: Peak
B4: Number of Tier
C2:
=IF(ROW()-1<=$B$4,"Tier "&ROW()-1,"")
To return Tier #
D2:
The lowest of the 1st tier is always the base
D3:
Simply the highest of the tier above plus 1. Drag down however long you want.
E2:
=IF(C2="","",B2+($B$3-$B$2)/5)
First highest = (Peak - Base) / Number of tiers
E3:
=IF(D3="","",D3+($B$3-$B$2)/5-1)
= Base of the Tier, plus the different of Peak & Base, divided by # of Tiers, and minus 1. Drag down however long you want.
I simply use normal calculation to get these numbers.
Bookmarks