On Aug 11, 12:11*pm, skoalnreds wrote:
If you have the total # units in A1 (I named the range A1 as
Units_Sold), then put the following in any cell (except A1):

=MAX(MIN(50000, units_sold)*1,0) + (MIN(MAX(units_sold-50000,0),
100000)*0.75) + =(MAX(units_sold-150000,0))*0.5

Sorry - typo: ignore the second "=" in the formula...