Use a Countifs function in cell E$5$ that returns the tax deduction amount for the number of dependents listed in the cell C$5.$ Use the table in range H$13$:I$17$ to complete the function. The maximum deduction is $$500\mathrm{.}00$; therefore, employees with more than four dependents will receive no additional deductions.