I need an excel formula. Fill in variables where necessary (highlight).

If an award is payable and is greater than 5% of the employees base pay, the first 5% of base pay may be contributed to the firms profit-sharing plan. The amount of the award above 5% will be paid to the employee in cash.