Here's how to calculate the amount in Microsoft Excel ... milestone value in column F of the tier table and returns the corresponding rate in column G. A VLOOKUP() function can do that.