Refer to the included Bike Safety Patrol Budget Spreadsheet. Cell E$4$ contains the discount amount for the item. The discount given $=5\%$ of the total cost if the total cost is less than $$100.$ Otherwise, the discount is $10\%$ of the total cost. Which of the following formulas would correctly calculate this discount for T$-$shirts?

Group of answer choices

$=$IF$($ D$4<100,0\mathrm{.}05*$D$4+$D$4,0\mathrm{.}1*$D$4+$D$4)$

$=$IF$($ D$4<100,0\mathrm{.}1*$D$4,0\mathrm{.}05*$D$4)$

$=$IF$($ D$4<100,0\mathrm{.}05*$D$4,0\mathrm{.}1*$D$4)$

$=$IF$($ D$4<100,5*$D$4,10*$D$4)$

$=$IF$($ D$4<100,10*$D$4,5*$D$4)$