TP - still not correct. The last column is out by a factor of 10 and the scaling is incorrect. Suppose on your spreadsheet the Award Amount is in US$ and the Converted Award is in AUD (seems to be how it works). Also suppose that the Converted Award is in column G, then the formula for the return to Shareholders (also in AUD) needs to be something like=if(Gn<=50000000, 0.3 * Gn, If(Gn > 100000000, 0.7 * (Gn - 100000000) + 40000000, 15000000 + (Gn - 50000000) * 0.5))