Question: 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

please dont just record a macro and paste the code. i

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

explan the code can i get you email to send the file? Lab 01 Chapter 1 : Algorithms, Errors, and Testing Chapter 2:Java Fundamentals Lab Objectives By completion of the lab the students should be...

I need help adding to the following program , the instructions are below it. Sorry for the long question, it is due by 11:55 PM Central ST. Here is the code that needs to be worked. /* Assignment:...

need help with this homework please. i need the answer as soon as possible .. thank you in advance Overview In this assignment you will write a program that will model a bank with multiple patrons...

in excel using developer 1. (4 points) Open a workbook, get into the VBE, insert a module, and enter the following code: Public Sub NowYouSeeMe0 Dim myName as String, nMiles as Integer yourName =...

can someone please help me!!! i keep getting stuck at step 5 Exp19_Excel_Ch12_Cap_Bulldog_Collectibles Project Description: You are the operations manager for Bulldog collectables, a small start-up...

No looping/iterations please. Create a new Excel Workbook named yourlastName P3.xlsm (replacing yourlastName with-your last namel) and write the VBA code to estimate employee P3.xism( payroll...

Hi I need help with this project that I am doing. It has to be in C language and I don't what to do. This is for my Data Structure course. Please it has to be in Language of C. Programming Assignment...

ALGORITHM DEVELOPMENT EXERCISE: To process the order, you will need constants and variables. Both have data types, and for numeric values, the preferred data types are Integer for whole numbers, and...

In Java Language. This is an intro class, so we haven't learned all that much, so if you could, try not to use too advanced formatting as we likely have not learned them. Please try and run all the...

How does financial accounting differ from tax accounting?

Let x be a Poisson random variable with mean = 2. Calculate these probabilities: a. P(x = 0) b. P(x = 1) c. P(x > 1) d. P(x = 5)

( b 1 ) Assume that if Blossom Water accepts Clifton's offer, the company can use the freed - up manufacturing facilities to manufacture a new line of growing lights. The company estimates it can...

The first scenario will be a Verbal Judo scenario in which your scenario follows the standard Verbal Judo interaction: You need to ask somebody to modify their behavior either to do something or to...

6. Identify seven types of hidden histories.

10. Describe a dialectic perspective in negotiating personal histories.

What is the relationship between humans and nature?