4. A bank offers different yearly interest rates to its customers based on the size of the deposit in the following way:

For deposits up to $1,000 the interest rate is 5.5 percent.
For deposits from $1,000 up to $10,000 the interest rate is 6.3 percent.
For deposits from $10,000 up to $100,000 the interest rate is 7.3 percent.
For all other deposits the interest rate is 7.8 percent.
Implement the function Interest(Deposit) in VBA. Note that you can use the Block If structure or the Select Case structure