The following does not provide a drop$-$down for the discount. Calculate the discount according to the formula.

"Total

Sale" Discount Score If the sales amount is $$1,000$ or greater, then calculate a $3\%$ discount, else calculate a $1\%$ discount.

$$500=$IF$($ A$62>=1000,$ A$62*3\%,$ A$62*1\%)$

$$1,000=$IF$($ A$63>=1000,$ A$63*3\%,$ A$63*1\%)$

$$2,000=$IF$($ A$64>=1000,$ A$64*3\%,$ A$64*1\%)$