Response:
=IF(C5>35000,IF(C5>25000<35000,IF(C5<25000,0.05*C5),0.04*C5),0.02*C5)
Justification:
Below is the formula intended to be entered in cell C8:
=IF(C5>35000,IF(C5>25000<35000,IF(C5<25000,0.05*C5),0.04*C5),0.02*C5)
This formula computes the bonus based on the provided data, utilizing the IF function. The formula begins with an equal sign, followed by IF and the application of all relevant terms.