please dont just record a macro and paste the code. i want it as a code using if statements

1. Write a VBA program that calculates the cost of renting a car according to the following price schedule: Sedan SUV Duration ofDailyFree miles Cost of mile $0.74 $0.64 $0.54 Daily Free mile Cost of mile S0.69 S0.59 $0.49 rent rate (per day) additional $79 $69 rate (per day)additional $84 $74 $64 1-6 days 80 100 120 80 7-29 days 100 30 or more daysS59 The program asks the user to enter the type of car (sedan or SUV), the number of days, and the number of miles driven. The program then displays the cost (rounded to cents) for the rent. Run the program three times for the following cases and write the answers on your cover page: (a) Sedan, 10 days, 769 miles. (b) SUV, 32 days, 4,056 miles (c) Sedan, 3 days, 511 miles