In cell c5, enter a formula that uses a nested if function to calculate the bonus. if sales in b5 are less $15,000, the sales person earns a 5% bonus. if the 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.