In cell C5, enter a formula that uses a nested IF function to calculate the bones, If sales in cell B5 are less $15,000, the sales person earns a 5% bonus. If sales are greater than or equal to $15,000 but less than $25,000, the sales person earns a 10% bonus. If sales are more than or equal to $25,000 the sales person earns a 15% bonus