n cell K6, write a formula that will determine the sales bonus paid.a.If the % goal reached is greater than 150%, then a bonus is 3% of thetotal 2021 sales is paid.b.If the % goal reached is less than or equal to 150% but greater thanor equal to 125%, then a bonus of 2% of the total 2021 sales is paid.c.If the % goal reached is less than 125% but greater than or equal to100%, then a bonus of 1% of the total 2021 sales is paid.d.If the % goal reached is less than 100%, then no bonus is paid