Formula for Extra Score in cell G8.

Question

ScanSolve AI Tutor · Accepted Answer

Here are the appropriate formulae for calculating the values in the spreadsheet, starting from row 8:

Formula for Extra Score in cell G8.
This calculates the score above the normal score (120) if the participant's score is higher than 120, otherwise it's 0. $=IF(E8 > \$J\$2, E8 - \$J\$2, 0)$
Formula for Normal Pay in cell H8.
This assigns 100,000 CFA if the participant's score is greater than 120, otherwise it's 0. $=IF(E8 > \$J\$2, 100000, 0)$
Formula for Extra Pay in cell I8.
This calculates extra pay for "Beginner" level participants who score above 120. It's the Extra Score multiplied by the Extra score rate (5000 CFA). $=IF(AND(D8 = \text{"Beginner"}, E8 > \$J\$2), G8 * \$J\$3, 0)$
Formula for Total Pay in cell J8.
This is the sum of Normal Pay and Extra Pay.
$=H8 + I8$
Formula for Tax in cell K8.
This calculates 5% tax on the Total Pay. $=J8 * \$J\$1$
Formula for Net Balance in cell L8.
This is the Total Pay minus the calculated Tax.
$=J8 - K8$

Step-by-step solution