Create two functions that computes the given for each state

Assignment Help JAVA Programming

Reference no: EM132081378

You need some VBA(excel) help. This is what you was given: 'Review the data on the 'Data worksheet'.

The data represents the Sales Tax information for the 50-city States in US. 'Create two functions that computes the following for each state:

'StateTax: ListedPrice * State Tax Rate 'Local Tax Rate: ListedPrice * Local Tax rate 'Determine Sales Amount as: ListedPrice + StateTax + LocalTax 'TotalTax as StateTax + LocalTax 'DiscountOpportunity as: MINIMUM(ListPrice * 2%, SalesTax * 1.5%) These are the two subs I was given to work off of:

Sub Part-A() Open textfile userCarDealership.txt Read the first 25 records, and then display those 25 records as Tab-delimited rows/lines in ONE Messagebox. End Sub Sub Part-B() Open textfile userCarDealership.txt Read the first 25 records, and load the records into the spreadsheet. Note: the starting cell for the load is A2. End Sub.

Reference no: EM132081378

Questions Cloud

If the us congress enacts new environmental legislation : If the US Congress enacts new environmental legislation, upon whom will they rely on to implement the legislation?

Pro argument for legalization : Using the perspective of ethical egoism, what are the issues with legalizing marijuana, using a pro argument for legalization?

Write a program that reads the earthquake : Write a program that reads the earthquake data.txt, and to process the earthquake data file and create lists of earthquake magnitudes and their dates.

Do gene and gob have a valid contract : Do Gene and Gob have a valid contract? Why or why not? Is there a way for either party to get out of the contract? Why or why not?

Create two functions that computes the given for each state : The data represents the Sales Tax information for the 50-city States in US. 'Create two functions that computes the following for each state.

Using the perspective of emotivism : Using the perspective of emotivism, what are the issues with legalizing marijuana?

How has predatory americans with disabilities act : How has predatory Americans with Disabilities Act (ADA) lawsuits been bad for the lodging industry?

Hazardous waste disposal site called industrial waste : Local Trucking, Inc. transports hazardous waste to a hazardous waste disposal site called Industrial Waste, Inc. Industrial sells the site to Venture Properties

Write examples with an code explanations of the oop : Write examples with an code explanations of the OOP (polymorphism, features encapsulation, inheritance and abstraction) with your program code.

User Account

All Pages